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
Then you call it in the code like this:
The CPAN documentation on Win32::OLE should provide all the detail you need.