> -----Original Message-----
> From: Jeffrey [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 08, 2002 5:38 PM
> To: Perl win32
> Subject: Excel SaveAs
>
>
> I'm having some difficulties with my SaveAs.
>
> I've opened the Excel file successfully (I know
> because 1: I checked the status of the open command,
> and 2: I can read from the file). I want to save it
> as a CSV file.
>
> I currently have:
> $workbook->SaveAs( {Filename =>
> "C:\\Download\\test.csv", FileFormat =>
> 'xlCSVWindows'});
Don't know if this is the cause of your problem or not, but FileFormat is a
constant, not a string. The above command should read:
$workbook->SaveAs( { Filename => "C:\\Download\\test.csv",
FileFormat => xlCSVWindows } );
Also, it probably wouldn't hurt to check Win32::OLE->GetLastError()
HTH,
Ian
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
