Issues with using the Excel Application Scope in a Shared Drive

Help
, ,
1

Hi,
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

Thanks,
ChrisL

2

Sounds like it is an access issue. Does the user this is running under have write access to that shared network location?

What happens if you try and save a .csv or a .txt file or anything else there?

3

I believe H: is the drive name to which you have mapped the shared folder? Try giving full path including machine name or ip !! This is just a work around I believe might work for your requirement.

4

@Dave @ArunVelaayudhanG

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)

Thanks

ChrisL

1 Like