in reply to Calling macros in Perl
Have a look at this node Using Win32::OLE and Excel - Tips and Tricks.
In that node its mentioned how to run macro.
Regards,Murugesan Kandasamyuse perl for(;;);