with a macro open a workbook without the Auto_Open running

[OlieH]

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 Pearson]

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]

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]

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)