Saving file that is already open

[ardykav]

Hi All,

Currently i have a macro which saves a file to 3 different locations on a shared drive. However if someone has the file open in one of the locations it returns an error and doesnt allow the macro to run properly. Is there an override code that i can use or possibly an alternative where if one location is open it saves the file as a different name?

All help greatly appreciated,

thanks

 

[DILIPandey]

Hi ardykav,

yes, it is possible.
You can place error handlers for each saving location and put a save as condition in case of error.


Regards,
DILIPandey

 

[ardykav]

Thanks Dili, would you be able to guide me in what code to use for the save as condition?

 

[DILIPandey]

I guess you are already having the code for Save As and now you need code to check the errors so that you can do a save as if file is open... correct?

If yes, see below link:-
Error Handling In VBA


Regards,
DILIPandey

 

[ardykav]

Thanks very much that's a great help

 

[DILIPandey]

You are welcome..



Regards,
DILIPandey