Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Win32::OLE support for Excel 2002
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... -
Win32::OLE support for Excel 2002
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 = %{... -
OLE Excel file saveAs comma delimited
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. -
Win32::OLE support for Excel 2002
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... -
Win32::OLE support for Excel 2002
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... -
Win32::OLE module - excel
Guys, Sorry, I put my question in your thread by mistake. Please disregard. Sorry again, Sid. -
Win32::OLE module - 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...
