opening a workbook with a macro without starting up the macro's of the new workbook
Posted by Luke on August 13, 2001 6:17 AM
I have tried to use all the tools I can find within the help files in excel97 and within a Book on VBA for excel2000 but somehow I cannot open a workbook from within an excel97 VBA macro without also activating the macro's in that workbook (workbook_open() sheet_activate() and such macro's within 'this workbook'). Even more, Excel does not even ask if macro's should be opened. I would like to do this so that I can update an older workbook laced with macro's with a newer version, or actually, import most or all of the worksheets out of another workbook on disk without being bothered with the macro's. Does anyone have the answer for me. The extension editable = true/false within the open command does not want to do the job. Best would be a command like "open('***') _ nomacro's" or "_deactivate macro's"
So, I should like to either open a workbook without activating its macro's or import worksheets from an unopened workbook.
If anyone can help I'd be gratefull