xlAutoOpen and GetActiveObject
 

Hey,
GetActiveObject() to get the running excel instance does not work
from xlAutoOpen since excel is not registered yet as running. Is there
another function to call to get the IUnknown or IDispatch for excel or
is there another entry point I need to define where GetActiveObject()
will work?

Omri

xlAutoOpen and GetActiveObject
 

Change auto_open to workbook_open.
*******************
~Anne Troy

www.piersontech.com
www.mrexcel.com


wrote in message
ups.com...
Hey,
GetActiveObject() to get the running excel instance does not work
from xlAutoOpen since excel is not registered yet as running. Is there
another function to call to get the IUnknown or IDispatch for excel or
is there another entry point I need to define where GetActiveObject()
will work?

Omri