Passing an OLE object through another OLE object

Kollin Patten

Delphi Developer

Sat, 20 Dec 2003 02:44:17 GMT

Passing an OLE object through another OLE object

I am fairly new at developing an automation object. I have set up an
interface for an application which allows me to access the application as an
out-of-process COM automation server. Within the original application, it
is possible for an instance of Excel to be initialized as an OLE object of
the application. What I need to do is somehow pass the instance of Excel
through my interface to an external program, in this case written in VBA, so
that the client program running MY interface as an OLE object can obtain
control of the Excel instance generated by my automation server. Can
someone give me some advice as to how this would be done? If I haven't made
clear what I'm trying to do, please let me know. Thanks.

Kollin Patten

Binh L

Delphi Developer

Sat, 20 Dec 2003 11:06:50 GMT

Re:Passing an OLE object through another OLE object

As long as you can access the second program through COM, you can pass it a
pointer to Excel using the VARIANT data type, for instance.

--
have fun
Binh Ly
http://www.techvanguards.com

Quote

"Kollin Patten" <kol...@powerworld.com> wrote in message

news:3b40c0e5$1_1@dnews...

Quote

> I am fairly new at developing an automation object. I have set up an
> interface for an application which allows me to access the application as
an
> out-of-process COM automation server. Within the original application, it
> is possible for an instance of Excel to be initialized as an OLE object of
> the application. What I need to do is somehow pass the instance of Excel
> through my interface to an external program, in this case written in VBA,
so
> that the client program running MY interface as an OLE object can obtain
> control of the Excel instance generated by my automation server. Can
> someone give me some advice as to how this would be done? If I haven't
made
> clear what I'm trying to do, please let me know. Thanks.

> Kollin Patten

Other Threads

1. How to pass an array of Single to a VB OLE object

2. Passing SafeArrays and/or COM objects as parameters to OLE Servers

3. Passing OLE Object

4. ole container vs ole object

5. More Excel, OLE ... Cell formatting via OLE Object

6. OLE Newbie: Controlling an OLE object from a Delphi 1 app

7. Delphi 2.01,Excel7.0a, OLE Error Method Workbooks not supported by OLE Object

8. Including OLE Automation object as member of object

9. Returning OLE/COM Object Instances from other objects

10. CL - Ole, Ole, Ole, Ole ?