[sf-perl] Win32::Excel
Peter Loo
loopeter at yahoo.com
Tue Apr 27 12:45:21 PDT 2010
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>
More information about the SanFrancisco-pm
mailing list