I’m currently having an issue regarding using the Excel Application Scope to create a new file (yes, the box is checked) in a Shared Drive. When I change the location of the file (the desktop) and it works, so as a temporary solution, I’m using my desktop to test instead of the shared drive. The issue is that in the long-run, I need to be able to create it (and save it) in the shared drive.
The error I keep getting is below:
Message: Microsoft Excel cannot access the file ‘H:\RPA\MH Testing 20180614\Test BDX with Address rules - Errors’. 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.
Thanks for the help, I tested out different scenarios in the shared drive using your suggestions.
They helped me realize that when the Excel Application Scope was creating the new file, because of how I was trying to rename the files and the file type (.xlsx) got removed, when I went back to add that in, it managed to work again! (For now at least)