View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fio[_2_] Fio[_2_] is offline
external usenet poster
 
Posts: 1
Default IF wokkbook1 is open, open workbook2 Loop

This is a little odd, but I would like to run a loop until a workbook i
free to write to it ...

I would like multiple users to write to a book - it doesn't matte
which one ... but I don't want them to get any 'wait' 'free to writ
to' share messages if it's active ...

If I have my book (active) , book1 (closed) and book2 (closed) ..
I would like to run a loop until either book1 or book2 are closed the
open the book, write to it, close the book ...

Currently I have -