in reply to How to convert VBA macro to Windows Perl
Using Win32::OLE, you can actually run the VB macro from the opened file if you want. First specify it as a package
package MacroName;
Then you call it in the code like this:
$YourWin32Object->Run("MacroName");
The CPAN documentation on Win32::OLE should provide all the detail you need.
In Section
Seekers of Perl Wisdom