Check read-only status, and if locked - skip all code and give a message box

Good Day,

I have the following code that opens up a file ARCHIVE.xlsb.

Please Login or Register  to view this content.

I need to check the file status before opening it, as someone else could be using it.

If the file is LOCKED, I need it to skip all the additional code and give me a message as follow: "Please retry in 5 seconds..."

I have tried multiple codes already - an goto error seems to be an option - But I cannot get it to work...

Any assistance will be greatly appreciated.

JEDEMEYER1

You could try to do a low level file open... The Operating System will throw an error if any other user, or process, has the file open.

Add the following to a module:

Please Login or Register  to view this content.

And change your code to :

Please Login or Register  to view this content.

Hi cytop,

No unfortunetlay it still does not work I did as you said, and it still ignores the read only status of the archive file.

I have it opened on another computer (This making it Read Only), and when I run the code it just does the whole thing, without stopping.

I am giving you my entire code:

Please Login or Register  to view this content.

I hope it helps you in finding out what I did wrong where.

Please.

JEDEMEYER1

Apologies, I had a typo in a couple of variable names... This version tested to return True when the original version returned False...

Please Login or Register  to view this content.

Thank You cytop!

Works like a charm.