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.