GetObject("",Excel.application)

[Art Yates]

I tried:

myxl=GetObject("",Excel.Application)


Just exactly as in the vb help file, but it doesn't work.

I have a VBA reference in my project.


This statement works OK:

Myxl=GetObjext("path\book.xls")


But it doesn't help if the .xls is already open.


TIA

[Jurgen Muller]

try this:


GetObject(,"Excel.Application")


Bye

Jurgen

[__Neph__]

hi guy,


try this


dim MyXL as object


set MyXL = getobject("","Excel.application")


It should work...


__Neph__

[ShengTian Liao]

Is there coresponding routine in VC like GetObject() in VB.

ShengTian Liao