OLE error when trying to run excel macro

llords has asked for the wisdom of the Perl Monks concerning the following question:

I am trying to upgraded to ActivePerl 5.8.7 from 5.8.4 on my Windows XP machine. I am now getting an Win32::OLE error on a statement that has worked correctly for quite awhile on the old system. The statement seems to work but throws the following message: Win32::OLE (0.1403) error 0x800a9c68 in METHOD/PROPERTYGET "Run" at line number. The statement is as follows: $Excel->Run("open_close"); I can open and execute the macro manually with no errors. I would appreciate any suggestions or alternatives.

Comment on OLE error when trying to run excel macro

Replies are listed 'Best First'.
Re: OLE error when trying to run excel macro by Grygonos (Chaplain) on Aug 09, 2005 at 16:54 UTC
Is your version of Win32::OLE the same as it was before? Grygonos	[reply]
Re^2: OLE error when trying to run excel macro by llords (Initiate) on Aug 09, 2005 at 17:09 UTC
Under 5.8.4 I am running Win32-AuthenticateUser 0.02 and under 5.8.7 I am using Win32-OLE 0.1403. I am not sure where the Win32-AuthenticateUser came from I am pretty sure I install Win32-OLE. I am not sure what the difference is?????? Thanks for your help!	[reply]
Re^3: OLE error when trying to run excel macro by holli (Abbot) on Aug 09, 2005 at 17:58 UTC
Sometimes a modules API changes during it's development or sometimes a specific version is just buggy. To be sure about the version of a module, open it's file and identify the line that looks like `our $VERSION = '1.2.5';` [download] That's the version (: holli, /regexed monk/	[reply] [d/l]