| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to check for Open File!
I am trying to check if a workbook is open and if it is select a tab. If the
workbook is not open, I was to open it. Any ideas? For Each wbk In Application.ActiveWindow If wbk.Name = "FC CONSTRUCTION TRACKER_V2.xls" Then Sheets("FC Construction").Select End If Next wbk Workbooks.Open ("S:\_TRACKERS\NJ Daily Totals\CM Update Trackers\FC CONSTRUCTION TRACKER_V2.xls") Windows("FC CONSTRUCTION TRACKER_V2.xls").Activate Sheets("FC Construction").Select |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check if file is already open | Excel Discussion (Misc queries) | |||
| If Then to check if a workbook is open | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
| Check if workbook open | Excel Discussion (Misc queries) | |||
Threaded Mode
