Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Skip workbook
I have created some vb to open another work book but if it is open it
goes to debug anyone have a skip if open script cheers jack |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Skip workbook
dim wkbk as workbook
on error resume next set wkbk = workbooks("book1.xls") '<- no drive, no path, just filename on error goto 0 if wkbk is nothing then 'open it, with drive, path, filename set wkbk = workbooks.open(filename:="c:\folder\folder\book1.x ls") end if wrote: I have created some vb to open another work book but if it is open it goes to debug anyone have a skip if open script cheers jack -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Skip workbook | Excel Worksheet Functions | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Quick Macro question - How to delete two rows then skip one - and repeat | Excel Discussion (Misc queries) | |||
Runing a macro in a workbook from another macro in other workbook | Excel Discussion (Misc queries) | |||
Sheets Skip Macro | Excel Discussion (Misc queries) |