Excel Events

  • Thread starter Thread starter Kenneth Hutson
  • Start date Start date
K

Kenneth Hutson

Hi Group,

VB.Net I'm displaying the names of the open Excel workbooks in a listbox on
my form. It looks as if it might be possible to monitor Excel's events
(OpenWorkbook in this case) and update my listbox.
If this is possible, could someone could point me in the right direction for
some reading material or provide some code as to how the mechanism works,
that would be great.

Thanks,
Kenneth Hutson
San Antonio, TX
 
VB.Net I'm displaying the names of the open Excel workbooks in a listbox
on my form. It looks as if it might be possible to monitor Excel's events
(OpenWorkbook in this case) and update my listbox.
If this is possible, could someone could point me in the right direction
for some reading material or provide some code as to how the mechanism
works, that would be great.
Click to expand...
I figured this out. Although I get an cross-thread exception (when my event
trues to update the listbox on my form) in Debug mode, the executable does
what I need to do. Sure would like to fix the underlying problem though.
Thanks,
Kenneth Hutson
San Antonio, TX
 
Back
Top