open up an excel program with an auto open macro

[john.9.williams]

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

 

[Norman Jones]

Hi John,

If you open Workbook B with code from Workbook A, the Autpen procedure in
WorkbookB will not run unless you explicitly stipulate that it should.

Conversely, Workbook B's Workbook_Open sub would run.

 

[Bob Umlas]

Before opening it, use
Application.EnableEvents = False