Open workbook from another workbook without firing the open workbook event?

Question

I have two workbooks integrated into the following workflow:

1. I export data from WB1 into WB2 2. I want to check, whether the data in WB2 are up to date.

In my VBA Code in WB1 I use

Workbooks.Open "C:\WorkbookName.xls"

to get my data from WB1 into WB2.

In WB2 I have VBA Code within the Open Event to check it the data is up to date.

PROBLEM: If I use Workbooks.Open "C:\WorkbookName.xls" the Open Event fires. Is it possible to avoid that and to manipulate the WB2 from WB1 without to activate the Open Event?

Demetri · Accepted Answer · 2015-10-09 13:43:07Z

3

This can be done by disabling the events before opening the file:

Application.EnableEvents = False

After opening the file you can enable the events again:

Application.EnableEvents = True

answered Oct 9, 2015 at 13:43

Demetri

8591 gold badge6 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

kolcinx Over a year ago

Correct. The aforementioned lines should be put into the WB1 code.

Collectives™ on Stack Overflow

Open workbook from another workbook without firing the open workbook event?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related