How to get acces to hidden instance of Excel

Topic

New Reply

Excel Version 2003

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

Reply | Quote

Replies

You might try this:
– Start another Office application such as Word, PowerPoint or Outlook.
– Press Alt+F11 to activate the Visual Basic Editor.
– Press Ctrl+G to activate the Immediate window.
– Type the following, then press Enter:

GetObject(, “Excel.Application”).Visible = True

This might make the hidden instance of Excel visible. It may not work, though, if the Automation code “hangs”.

Reply | Quote

You might try this:
– Start another Office application such as Word, PowerPoint or Outlook.
– Press Alt+F11 to activate the Visual Basic Editor.
– Press Ctrl+G to activate the Immediate window.
– Type the following, then press Enter:

GetObject(, “Excel.Application”).Visible = True

This might make the hidden instance of Excel visible. It may not work, though, if the Automation code “hangs”.

Thanks Hans. Have you (or anyone else reading this post) ever heard of someone being able to do something like this with Excel 2003?

Reply | Quote

Thanks Hans. Have you (or anyone else reading this post) ever heard of someone being able to do something like this with Excel 2003?

If you mean whether I have been able to make a hidden instance of Excel visible using GetObject(, “Excel.Application”).Visible = True, the answer is yes, frequently.

Reply | Quote