Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am building an application in one workbook that requires another
workbook be open. Here is the code I am using: Private Sub OB1_Click() Workbooks.Open Filename:="C:\Data1.xlsx" UF1.Hide End Sub This does the job, but what is the code that determines if this workbook "C:\Data1.xlsx" is already open so it doesn't try and re-open it? Thank you, Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
code to open another workbook | Excel Programming | |||
code to open another workbook | Excel Programming | |||
Need VB code for workbook open to open a link | Excel Discussion (Misc queries) | |||
Code to open new workbook | Excel Programming | |||
Workbook Open code | Excel Programming |