| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open up an excel program with an auto open macro
Hi,
I have a program that i am working on, with this program i wish to open up another workbook, and copy some data from it. The problem is that the workbook i want to access has an Auto open program that loads a userform as soon as its open. Is there a way that I can stop this macro from working using code from my new program when my new program opens up the other workbook. regards John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
open up an excel program with an auto open macro
Hi John,
If you open Workbook B with code from Workbook A, the Auto_Open procedure in WorkbookB will not run unless you explicitly stipulate that it should. Conversely, Workbook B's Workbook_Open sub would run. --- Regards, Norman wrote in message oups.com... Hi, I have a program that i am working on, with this program i wish to open up another workbook, and copy some data from it. The problem is that the workbook i want to access has an Auto open program that loads a userform as soon as its open. Is there a way that I can stop this macro from working using code from my new program when my new program opens up the other workbook. regards John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
open up an excel program with an auto open macro
Before opening it, use
Application.EnableEvents = False wrote in message oups.com... Hi, I have a program that i am working on, with this program i wish to open up another workbook, and copy some data from it. The problem is that the workbook i want to access has an Auto open program that loads a userform as soon as its open. Is there a way that I can stop this macro from working using code from my new program when my new program opens up the other workbook. regards John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Excel file from VB and open MACRO | Excel Discussion (Misc queries) | |||
| I cant open files unless I open the Excel program first | Excel Discussion (Misc queries) | |||
| Open another program(Word) with Excel macro? | New Users to Excel | |||
| can't open 2 excel program a once | Excel Worksheet Functions | |||
| Auto execute macro when open excel | Excel Programming | |||
Linear Mode
