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

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

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