M
Missing Excel Debug
Our main application uses Excel via automation to produce financial reports.
Up until recently we could always debug this process by dropping a STOP
command within the code module for the Excel Addin. Somehow with a recent
update the vendor has changed the way their product calls Excel via
automation so that even a STOP command followed by by a line setting the
Visible property to TRUE will not stop Excel.
Any way to grab a hold of or hook into Excel when this happens? We've had
some dooseys (problems) before that in the past we've found it much easier
and faster to fix ourselves but we have to be able to see what line of code
in the add-in that Excel is hanging up on as well as various varable values
and we can't now.
Thanks
Up until recently we could always debug this process by dropping a STOP
command within the code module for the Excel Addin. Somehow with a recent
update the vendor has changed the way their product calls Excel via
automation so that even a STOP command followed by by a line setting the
Visible property to TRUE will not stop Excel.
Any way to grab a hold of or hook into Excel when this happens? We've had
some dooseys (problems) before that in the past we've found it much easier
and faster to fix ourselves but we have to be able to see what line of code
in the add-in that Excel is hanging up on as well as various varable values
and we can't now.
Thanks