Correct. You may have to send a windows message to the Excel window and then
GetObject will work.
This is in the msdn as well.
--
www.alignment-systems.com
"David Welch" wrote:
In my experience GetObject won't work if the Excel window has not been
activated. I think this would
be the case if Excel was started like:
Set xlapp = New Excel.Application
since the window is hidden by default?
Ignore the highlighting in this email!!