Hi,
I have a requirement from our customers to convert excel files to text files. I was provided with a PowerShell script to convert excel to text to be run every day. When I run the script from PowerShell the script runs as expected converts excel files to text files but when I schedule and run it through task scheduler it is erroring with the below log,
Microsoft Excel cannot access the file 'E:\Test_reports\PaymentWarehouse\test\ETPAY-en_2021-07-21T092301719Z.xlsx'.
There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
•
The workbook you are trying to save has the same name as a currently open workbook.\n
Please let me know if anyone got an idea,
Thanks