Thread: Open Workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Matt is offline
external usenet poster
 
Posts: 516
Default Open Workbook

I want to be able to perform actions conditional on if a specific workbook is
open or not - so, if it isn't already open, I want to open it, but if it is
open, I want to just activate it....would it be something like:

If Workbooks("Updated Responder Data.xls").Open = False Then

Workbooks.Open Filename:= _
ActiveSheet.Range("I1").Value & "Updated Responder Data.xls"

End If

If Workbooks("Updated Responder Data.xls").Open = True Then

Windows("Updated Responder Data.xls").Activate

End If

Thank you ahead of time!!