Re^7: Problem using SaveAs when trying to change Excel format

$Book->SaveAs($file_name);

works for me, unless the file $file_name is already existing. I usually solve that problem by trying to delete the file before overwriting it.

If SaveAs() is still not working, verify the path (and try both, slashes and backslashes - excel seems to be a bit picky about them)

HTH, Rata

Comment on Re^7: Problem using SaveAs when trying to change Excel format Select or Download Code

Replies are listed 'Best First'.
Re^8: Problem using SaveAs when trying to change Excel format by Anonymous Monk on Jul 09, 2014 at 13:07 UTC
Hi Rata, I'm very thankful for your help ( :) ) but I want to edit the $file_name and want to save the changes in the same file.	[reply]
Re^9: Problem using SaveAs when trying to change Excel format by Ratazong (Monsignor) on Jul 09, 2014 at 13:46 UTC
To edit a file, use `$book->Save();` instead of `$book->SaveAs($filename);` HTH, Rata	[reply] [d/l] [select]
Re^9: Problem using SaveAs when trying to change Excel format by Anonymous Monk on Jul 09, 2014 at 13:09 UTC
Also slashes and backslashes, both are not working in my case.	[reply]