I have an xla (workbook a) that loads when excel starts. The xla
contains forms, classes and modules that are used to validate and load
data via a web service.

The data is coming from another workbook (workbook b) that is either
loaded into excel on demand through the normal file/open menu, or the
user may have double-clicked the file icon in windows explorer or
wherever. In either case, the workbook is open in the same instance of
excel as the xla.

My problem is that I must trap the double-click event of the workbook
that holds the data. The "ThisWorkbook" module holds that event, and I
cannot put any executable code in the event handler.

I have tried using a technique that involves creating a class and
declaring a WithEvents within that class similar to the following:

Public WithEvents actvWkBk as Workbook

that does not seem to work.

So the double-click event of workbook b, must somehow be trapped in
workbook a.

Any help will be greatly appreciated.

you need application level events.
see http://www.cpearson.com/excel/AppEvent.htm


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


mp112849 wrote :

I have an xla (workbook a) that loads when excel starts. The xla
contains forms, classes and modules that are used to validate and load
data via a web service.

The data is coming from another workbook (workbook b) that is either
loaded into excel on demand through the normal file/open menu, or the
user may have double-clicked the file icon in windows explorer or
wherever. In either case, the workbook is open in the same instance
of excel as the xla.

My problem is that I must trap the double-click event of the workbook
that holds the data. The "ThisWorkbook" module holds that event, and I
cannot put any executable code in the event handler.

I have tried using a technique that involves creating a class and
declaring a WithEvents within that class similar to the following:

Public WithEvents actvWkBk as Workbook

that does not seem to work.

So the double-click event of workbook b, must somehow be trapped in
workbook a.

Any help will be greatly appreciated.

Thanks, keepITcool! This works when I open the data file with a
double-click from windows explorer. I haven't had a chance to try it
while opening the file once an instance of excel is running (from a
file/open), but will do that later.