Thanks dmazzini for all your help.
The difference in the Excel constants between the 2 Excel versions was causing the problem. Since my code was using the constants for the FileFormat property it was failing.
I have used the new equivalent constants from Excel 2002 and my script worked.
xlText...
Thanks! The script worked for me too. So the enviroment is not the issue.
But the script has narrowed down the issue here. It seems like its the usage of SaveAs method that's not working with Excel 2002.
Some snippets from my code:
use vars qw( %xlConst );
%xlConst = %{...
goboating,
I am new to using Win32::PLE and I am having the same problem. However, it isn't clear how and if you were to fix the issue based on the issue.
Can someone please explain?
Thanks,
Sid.
hi dmazzini
Its kinda wierd. The call to:
my $excel = Win32::OLE->new('Excel.Application','Quit');
succeeds just fine, but when I try to use the excel object it seems as if it's corrupt or invalid.
I just get the following error:
Win32::OLE(0.1402) error 0x800a03ec
in METHOD/PROPERTYGET...
Hi
I recently switched from Win2K to WinXp and my perl script that used Win32::OLE to work with Excel stopped working.
I found out that the ActivePerl version 5.6.x that I was using supposedly only works with Excel 2000 (MS Office Obj. Library 9.0). And my WinXP install, I believe has Excel...
Hi
I recently upgraded from Win2K to WinXp and my perl script that used Win32::OLE to work with Excel stopped working.
I found out that the ActivePerl version 5.6.x that I was using supposedly only works with Excel 2000 (MS Office Obj. Library 9.0). And my WinXP install, I believe has Excel...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.