Wait on File.readonly

Hi all

I have a multiple user program and all save to the same workbook(s). Now here is the problem.

I need a 5 second delay to allow the file to become available before continuing with the operations
in all my attempts I created an infinity loop that crashes the PC

During the delayed time I want to display a nice message.

Thanks

Thanks Kadeo the infinity loop is gone but to get it to work will take some work

Kadeo

Please Login or Register  to view this content.

served me better but you set me on the right track

thanks

Or use API,

Please Login or Register  to view this content.

then in your sub e.g. add (for 1 sec wait, in milliseconds),

Please Login or Register  to view this content.