Are you sure you recorded the macro correctly?

I know for a fact that recording a macro will provide the VB code to do this task and it can be converted into Perl code that uses Win32::OLE. This is based on the fact that I've written Perl code to do exactly this and figured it out from recording a macro and looking at it's VB source code.

If I can find the time, I'll try to find and dig up my code to see how I did it. In the meantime, you'll find that recording macros and the OLE browser from the Win32::OLE module will be among your best resources.