Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following for some buttons.
To open I have: Workbooks.Open Filename:= "\\bo-10\ToP\ToP Bark\PI\aPM\PMP.xls" I then have another button to go back to that sheet if it's already open. Windows("PMP.xls").Activate I need to know what the "IF" statement is so I dont' have to have 2 buttons. How do I say: If "\\bo-10\ToP\ToP Bark\PI\aPM\PMP.xls" is open, activate PMP.xls, else open "\\bo-10\ToP\ToP Bark\PI\aPM\PMP.xls" I keep trying to do it and getting it wrong. Help? Thank you, Gee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel |