Events in another workbook.
 

Im looking for a way to handle an event in a second workbook. I have a
control file that requires a user to open a target file of their choice, and
I want to trigger on events in the target file to produce a result visible to
the user. The target files have a uniform structure, but they are user
created, so I cant populate them in advance with the event handler. I
thought of creating an .xlt, but users have generally cut their files out of
a large database and I cant depend that they would use the template. I
could create a helper sheet in the control file to replicate the target,
trigger on its changes, and write the results back to the target. Maybe even
have the user just work in the replica and then overwrite the target file
when they finish.

Any thoughts?

--
Al C

Events in another workbook.
 

Your question is a little convoluted but check out this link...

http://www.cpearson.com/excel/Events.aspx
http://www.cpearson.com/excel/AppEvent.aspx
--
HTH...

Jim Thomlinson


"Al" wrote:

Im looking for a way to handle an event in a second workbook. I have a
control file that requires a user to open a target file of their choice, and
I want to trigger on events in the target file to produce a result visible to
the user. The target files have a uniform structure, but they are user
created, so I cant populate them in advance with the event handler. I
thought of creating an .xlt, but users have generally cut their files out of
a large database and I cant depend that they would use the template. I
could create a helper sheet in the control file to replicate the target,
trigger on its changes, and write the results back to the target. Maybe even
have the user just work in the replica and then overwrite the target file
when they finish.

Any thoughts?

--
Al C

Events in another workbook.
 

I take it you are pointing me toward Application events, which I haven't used
before. That sounds like the way to handle events in any workbook (with
appropriate target selection). I really should have looked at Chip's site
before asking the question.

Thanks for the help.
--
Al C