workbooks.open without triggering event
 

Hello,

I'd like to know if any possibility exists to open a workbook (vi
workbooks.open or similar call) without triggering workbook_open even
in target workbook ?

Thanks,

Vobiscu

--
Vobiscu
-----------------------------------------------------------------------
Vobiscum's Profile: http://www.msusenet.com/member.php?userid=245
View this thread: http://www.msusenet.com/t-187055645

workbooks.open without triggering event
 

Not sure if this would work, but you can disable events just prior to opening
the new workbook. (I haven't tried it yet for opening external items.)

To do this:

Application.EnableEvents = false 'Stops ALL (I think) automatic events from
occurring

Open new work book and do anything that you want to do before allowing
events to occur again.

Application.EnableEvents = true 'Allows events to be processed again.


"Vobiscum" wrote:


Hello,

I'd like to know if any possibility exists to open a workbook (via
workbooks.open or similar call) without triggering workbook_open event
in target workbook ?

Thanks,

Vobiscum


--
Vobiscum
------------------------------------------------------------------------
Vobiscum's Profile: http://www.msusenet.com/member.php?userid=2459
View this thread: http://www.msusenet.com/t-1870556454

workbooks.open without triggering event
 

Thanks for your answer. I'll try today.

Vobiscu

--
Vobiscu
-----------------------------------------------------------------------
Vobiscum's Profile: http://www.msusenet.com/member.php?userid=245
View this thread: http://www.msusenet.com/t-187055645