Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking for the VBA to identify if a workbook is already open and, if
not, to open it, otherwise to open the workbook window. I have:- i) Worksbooks.Open("Filename.xls") and ii) Windows("Filename.xls).Activate but I require somethiing to stop the 'overwrite' message popping up after running i), if already open, and then running ii) Hope this makes sense Any help appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
How to identify variable workbooks in an excel Addin | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
Identify if another user has spreadsheet open - in VBA | Excel Programming | |||
Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming |