I wish to open a workbook that has Auto_Open installed. I merely want to
extract information from a specific cell. My proglem is that the workbook
when opend will run Auto Open. Is there a way to prevent the Auto_Open macro
from execuiting?
I appreciate the help.

Olie

Olie,

Hold down the SHIFT key when you open the file and the code won't run.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"OlieH" wrote in message
...
I wish to open a workbook that has Auto_Open installed. I merely want to
extract information from a specific cell. My proglem is that the workbook
when opend will run Auto Open. Is there a way to prevent the Auto_Open
macro
from execuiting?
I appreciate the help.

Olie

Chip thanks for the reply. I am opening the workbook from within a macro in
a different workbook. I did get the workbook to open without executing the
Auto_Open. Now my problem is that in the "opened workbook" I have a
before_close event that is triggered, when I tried to close the 2nd workbook.
Any way to prevent the before_close macro from running from within the first
opened workbook?

"Chip Pearson" wrote:

Olie,

Hold down the SHIFT key when you open the file and the code won't run.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"OlieH" wrote in message
...
I wish to open a workbook that has Auto_Open installed. I merely want to
extract information from a specific cell. My proglem is that the workbook
when opend will run Auto Open. Is there a way to prevent the Auto_Open
macro
from execuiting?
I appreciate the help.

Olie

If you are opening the file via VBA code, the Auto_Open macro won't run, but
the Workbook_Open event will run. You can disable all events (such as
BeforeClose) with code like

Application.EnableEvents = False
' do something
Application.EnableEvents = True


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"OlieH" wrote in message
...
Chip thanks for the reply. I am opening the workbook from within a macro
in
a different workbook. I did get the workbook to open without executing
the
Auto_Open. Now my problem is that in the "opened workbook" I have a
before_close event that is triggered, when I tried to close the 2nd
workbook.
Any way to prevent the before_close macro from running from within the
first
opened workbook?

"Chip Pearson" wrote:

Olie,

Hold down the SHIFT key when you open the file and the code won't run.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"OlieH" wrote in message
...
I wish to open a workbook that has Auto_Open installed. I merely want
to
extract information from a specific cell. My proglem is that the
workbook
when opend will run Auto Open. Is there a way to prevent the Auto_Open
macro
from execuiting?
I appreciate the help.

Olie