[sf-perl] Win32::Excel

[Peter Loo]

Hello All,
 
I have the need to execute an Excel Macro which in turn will refresh the Pivot tables.  This Excel macro is on a shared mapped drive.
 
What I need to do is run the Excel ".xls" file once a day.
 
Is there an easy way to do this?  
 
I have looked into Win32::Excel::Refresh and have attempted to install it on my Windows 2003 Server x64 Edition and am having problems with dependencies.  Below is the errors that I am receiving.
 
No type library matching "Microsoft Excel" found at /PerlApp/Win32/Excel/Refresh.pm line 15
Win32::OLE(0.1502): GetOleTypeLibObject() Not a Win32::OLE::TypeLib object at /PerlApp/Win32/OLE/Const.pm line 45.
Win32::OLE(0.1502) error 0x800401f3: "Invalid class string" at XLRefresh.pl line 85
Can't call method "Workbooks" on unblessed reference at /PerlApp/Win32/Excel/Refresh.pm line 95.
 
Thanks.
 
Peter


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/sanfrancisco-pm/attachments/20100427/dca953ae/attachment.html>