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.
Exception Type: ExcelException