>>>GETOBJECT() has two forms. You want the other one. From the Hacker's Guide:
>
>>>Omitting the first parameter and passing "Excel.Application" for the second starts Excel if it is not running, or grabs another handle >>to the application if it is executing.
>
>If I try createobject(myapp.myoleobject) I get the object returned successfully, if I try getobject(,myapp.myoleobject) I get an error "0x800401e3 operation unavailable".
>
>I understand this means my application is not in the Running Object Table (ROT) ? any ideas how to resolve this?
>
>Gary.
I had it working using this
http://www.theproblemsolver.nl/download.htmIt was an article called "Debugging COM servers under XP"
[Update]Which I can not find any longer...[/Update]
[Update 2] Ah, I found it now, I better take out the code and put back the link to the source
http://www.theproblemsolver.nl/downloads_vfp.htm#Debugging%20COM%20servers%20under%20XP[/Update 2]
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges