VBA: If workbook is open code

[danelskibr]

Hello,

I am looking for code that will check to see if a particular workbook is open (named "The Sheet").

-If it is open, then I would want to go to this workbook.
-If it is not open, I would like to open it

Any Ideas?

Thanks!

 

[Fishboy]

Hello,

I am looking for code that will check to see if a particular workbook is open (named "The Sheet").

-If it is open, then I would want to go to this workbook.
-If it is not open, I would like to open it

Any Ideas?

Thanks!

Hi Daniel, try this:

Sub OpenDoc()
Workbooks.Open "C:\Users\Fishboy\Documents\The Sheet.xls"
End Sub

You will obviously need to change the filepath to match where the file is located. If the file is not open, it will open. It is is open, it will activate.