Fileopen Logic

Hi,

I've this piece of code written to always open the file in read-write mode (a shared file being used by multiple users at a time - Being used as a database).

Could you please check.. improve the logic or the code or suggest better or simple methods? Thanks a ton

"FolderName" contains the path to the file
"WorkBookName" contains the actual file name

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks a lot again...

You could shrink your code by using the below function and macro, This will not loop but you can adpate so it will loop.

Excel does automatically tell you if the file is already open by other user when working on a network.

I hope this helps you

Function

Please Login or Register  to view this content.

Macro:

Please Login or Register  to view this content.