note Corion <p>In addition to this very good introduction, here's my approach to automating things in Excel that I know how to do manually in Excel. These steps apply to any (Office) application that has a macro recorder:</p> <ol> <li>Start the Excel Macro Recorder</li> <li>Perform the desired action(s) manually, for example, delete a row or bolden text or create a pivot chart</li> <li>Stop the Excel Macro Recorder</li> <li>Inspect the generated VB code</li> <li>Check that the generated VB code does what you want</li> <li>Translate the generated VB code to Perl / Win32::OLE invocations</li> </ol> <p>That's all there is to it and it sure beats poring over the documentation to find out the needed function names.</p> <p>Similar lists exist at [id://497508] and [id://310200], but as this appears to be a good starting page for people working with Win32::OLE, I figured to put it here as well.</p> 153486 153486