| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for open workbook
Hi.
I need to create vba code within a excel macro to detemine if a workbook is already open. If it is, I want to continue with the macro. If it isnt, I want to open the workbook and then continue with the macro. I am sure this must be pretty easy. I'm just struggling to work out how to do it. Can anyone give me some suitable code. Many thanks in advance. Nigel ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
| how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| testing. do not open. | Excel Worksheet Functions | |||
Threaded Mode
