| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to check for Open File!
You do not need to check if it is open. Hyperlink to it. If it is already
opened you will jump to it, otherwise it will be opened: Sub anothre() Dim s As String s = "S:\_TRACKERS\NJ Daily Totals\CM Update Trackers\FCCONSTRUCTION TRACKER_V2.xls" ActiveWorkbook.FollowHyperlink Address:=s Sheets("FC Construction").Select End Sub -- Gary''s Student - gsnu200799 |
| Reply |
| 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) | |||
Hybrid Mode
