Save to Network drive giving "Someone is Using that file" warning and won't save---how to handle

codeliftsleep

Board Regular
Joined
Apr 14, 2017
Messages
103
I am attempting to fully automate some processes overnight, but this is the one thing causing some issues right now.

I have found a solution to automating the Classification system my company employs by calling functions that set the mouse position and then click which then allows me to save without a popup coming up asking for the type of file classification.

However, I have a situation where I am saving to the network drive and at various times I get the "Cannot save file---someone else is using it right now" message when I attempt to save it. So I need to know my options here.

I have to save the file successfully before I can continue because I need the information to update the following day's info. I've tried updating the Trust Settings as some people have found helpful but that didn't work for me, still having the issue intermittently.

Is there a way to handle the "failed save" event and then continue attempting to save until it does so successfully(sometimes it takes up to 3 tries, sometimes it does it on the first try). Like set up an error handler to resume at that line if it fails?

I've also read a user who gets the file, immediately saves it to the local drive and then opens that file, works on it and then saves it to the network drive when done which apparently bypasses this issue since the file is not open when it's being saved, but I'd rather not do this if possible.
 
Last edited:

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,223,262
Messages
6,171,080
Members
452,377
Latest member
bradfordsam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top