Update closed workbooks & check if already open

Hi

I've entered the below code in my workbook, and it's working perfectly. However I hadn't considered that some of the files that the code opens, update and save could already be open by another user on the network.

But I can't figure out how to adjust my code so it doesn't update already opened files? And at the same time I would like a msgbox so popup and tell the user that, file XXX hasn't been updated.

Is this possible?

Please Login or Register  to view this content.

I appreciate all the help I can get

Thanks

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg

It's really nice code, and it's almost working.

But when a file is open by another user, this code still opens the file, just in a "write protected" version and opens the "save as" menu. Which I have to close before your code finish.

Do you know how to avoid that?

I really appreciate the help

true adding in

Please Login or Register  to view this content.

That doesn't change anything.,

I guess I need some sort of code here:

Please Login or Register  to view this content.

That just closes the workbook again?

Hi again,

Sorry about that - trying to test a solution in a "simulated" environment sometimes allows glitches to pass unnoticed.

See if the following version works for you:

Please Login or Register  to view this content.

Hope this helps - as before, please let me know how you get on.

Regards,

Greg M

Hi again,

If the above proposal works for you, it might be more efficient to store the names of the already opened workbooks and display them in a single list at the end of the process rather than continually interrupting the process with individual messages.

I can implement this for you if you wish.

Regards,

Greg M

Hi Greg

This works perfectly!!!! Just what I wanted... Thanks alot..

Sure if possible it wouldn't hurt to have a single list at the end, so if you have time, I would like that.

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

Your wish is my command!

See if the following code does what you need:

Please Login or Register  to view this content.

As before, please let me know how you get on.

Regards,

Greg M

Hi Greg

yet again you've done it!

It works perfectly

Thank you so much for your help.

Hi again,

Many thanks for your feedback - I'm very pleased that I was able to help.

Best regards,

Greg M