| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF wokkbook1 is open, open workbook2 Loop
http://support.microsoft.com?kbid=138621 XL: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=291295 XL2002: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=213383 XL2000: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=184982 WD97: VBA Function to Check If File or Document Is Open -- Regards, Tom Ogilvy "Fio " wrote in message ... This is a little odd, but I would like to run a loop until a workbook is free to write to it ... I would like multiple users to write to a book - it doesn't matter which one ... but I don't want them to get any 'wait' 'free to write 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 then open the book, write to it, close the book ... Currently I have - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
| VBA loop slow if another workbook open | Excel Discussion (Misc queries) | |||
| file won't open, endless loop, autorecover | Excel Discussion (Misc queries) | |||
| open files in loop with date order | Excel Discussion (Misc queries) | |||
| Can I have a loop to open a set of workbooks get some data, close it one a time. | Excel Programming | |||
![Fio[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
