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
|