Re^6: Getting an exception while reading excel file using Win::OLE from a current directory

Directory and File Path are printed correctly but unable to save as again .. Same Error.. Not allowing adding updated_ in front of the excel sheet ... Below Is the Error I am getting :

Trying to save to directory updated_E:/Automation Related/Perl Scripts - ALL/IM S_debugging/Final_Scripts/Final_Script_Working Trying to save to file updated_E:/Automation Related/Perl Scripts - ALL/IM S_debugging/Final_Scripts/Final_Script_Working\Parameters.xlsx OLE exception from "Microsoft Office Excel": The file could not be accessed. Try one of the following: ò Make sure the specified folder exists. ò Make sure the folder that contains the file is not read-only. ò Make sure the file name does not contain any of the following characters: < > ? : | or * ò Make sure the file/path name doesn't contain more than 218 characters. Win32::OLE(0.1712) error 0x800a03ec in METHOD/PROPERTYGET "SaveAs" at E:\Automation Related\Perl Scripts - ALL\I MS_debugging\Final_Scripts\Final_Script_Working\IMS_Debug_Script_V5.pl line 591.

Comment on Re^6: Getting an exception while reading excel file using Win::OLE from a current directory

Replies are listed 'Best First'.
Re^7: Getting an exception while reading excel file using Win::OLE from a current directory by rockyurock (Acolyte) on Feb 28, 2017 at 10:16 UTC
It;s asking me to overwrite the existing excel file rather creating a new excel file as mentioned in the script .. updated_Excelfile.	[reply]
Re^8: Getting an exception while reading excel file using Win::OLE from a current directory by Corion (Patriarch) on Feb 28, 2017 at 10:23 UTC
Seriously, please read your debugging output. On Windows, `updated E:\` is not a valid directoryname or filename. All other errors are simply consequents of that initial error.	[reply] [d/l]