[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.

-------------- 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