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

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



<[email protected]> wrote in message
news:[email protected]...
> 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
>

Before opening it, use
Application.EnableEvents = False

<[email protected]> wrote in message
news:[email protected]...
> 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
>