open up an excel program with an auto open macro

  • Thread starter Thread starter john.9.williams
  • Start date Start date
J

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
 
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.
 
Back
Top