View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default 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