<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>Hello All,</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>What I need to do is run the Excel ".xls" file once a day.</DIV>
<DIV> </DIV>
<DIV>Is there an easy way to do this? </DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV><FONT size=4 face="Courier New">No type library matching "Microsoft Excel" found at /PerlApp/Win32/Excel/Refresh.pm line 15<BR>Win32::OLE(0.1502): GetOleTypeLibObject() Not a Win32::OLE::TypeLib object at /PerlApp/Win32/OLE/Const.pm line 45.<BR>Win32::OLE(0.1502) error 0x800401f3: "Invalid class string" at XLRefresh.pl line 85<BR>Can't call method "Workbooks" on unblessed reference at /PerlApp/Win32/Excel/Refresh.pm line 95.</FONT></DIV>
<DIV><FONT size=4 face="Courier New"></FONT> </DIV>
<DIV><FONT size=4 face="Courier New">Thanks.</FONT></DIV>
<DIV><FONT size=4 face="Courier New"></FONT> </DIV>
<DIV><FONT size=4 face="Courier New">Peter</FONT></DIV></td></tr></table><br>