Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing if a file is open
Hi,
Can someone provide some direction on how to test if an Excel file is currently open....not worried about whether it is active, just currently open. I'm requesting the information from VBA for Word 2000. I've tried the following: if Excel.application.workbooks(vFileName).open = true .... End if It isn't working! Any ideas would be very much appreciated. Thanks, Jille |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
testing. do not open. | Excel Worksheet Functions | |||
Testing if file is open | Excel Programming | |||
Testing for an open file | Excel Programming | |||
Testing if a file is open | Excel Programming | |||
Testing for open workbook | Excel Programming |