I run update macro loop to process about 50 spreadsheets, but sheets could
be used (open) by somebody. I need to skip processing of the sheet if it is
open. Something like this:
For R = 1 to 50
If FileR is open then goto Skip '<======This is what I need
Open_sheet
Update_it
Save_and_Close_it
Skip:
Next R
Thanks for your help
Jan
Bookmarks