Ignore open by other user message box

[Finndus]

Does anybody know how to get over the file open by other user message box that excel throws up?

I'm trying to make my program fail safe for my users......

 

[Joe4]

Is the file saved as a "shared workbook" so that multiple users can update it simultaneously?
How does removing that message make it "fail safe" for other users?
It seems to me that removing that message could cause more problems than it solves, especially if it is not shared, as the subsequent users would not be able to save their changes back to the original file.

 

[Finndus]

Ok,

I was probably being slightly vague, sorry.

The idea is not to overwrite a file if it is open but instead close it and then the program can continue. Basically if a user forgets to close the file and calls the macro again (called from another program), excel will stop, i just need it to continue - the file which the user would want would be the file that the user ran the program on, hence the old file is not needed.

Cheers

 

[Joe4]

I am sorry to say, but I find your last post a bit confusing.

 

[Finndus]

If the user were to forget to close the previous file, make changes in another program and then re-run the macro (called from the other program) - a read-only box appears - I want to override this, close the open, old file so excel can continue with opening the new file (same file name as old file) and continue with the macro, ultimately re-saving over the old file.

I hope that makes things clearer.

 

[Smitty]

Welcome to the Board!

I'd check and see if the file is open before the code runs. Here's some code to let you do that: http://www.vbaexpress.com/kb/getarticle.php?kb_id=443

If it's already open then activate it, otherwise open it.

HTH,

 

[Finndus]

Thanks Smitty,

I'm getting a file locked by user message, open as read only..... - the macro wont make the open file active to close..

Any ideas?

 

[Smitty]

Then you're SOL.

Try to figure out a way to not make the process reliant on that workbook. Like work on an intermediate workbook the other user won't use, but you can link him to it.