OLE Identifiers

Misael Santos wrote:

> Hi everybody,
> I'm trying to access some OO objects from a Forms
(Oracle) application using
> Native OLE Automation.
> It works fine for MS Office objects, using strings like
"Excel.Sheet", the
> OLE programmatic Identifiers.
> The question is, how do I get the strings for reference
OO objects like a
> sheet? It's possible?
> I need to run macros and get their results from the
open office calc.

The whole OOo API is accessible through OLE automation, only
exception
handling doesn't work IIRC. Using OLE automation means using
the
IDispatch interface of COM objects. Usually this is a PITA
except when
you have a programming language that interprets this
interface and
presents it to its users in an easier way like VBA does. A
term like
"Excel.Sheet" seems to indicate that you have such
a language.

Of course the OOo API is different than the MSO API, but
describing it
is nothing you can do in a single mail.

Best regards,
Mathias

-- 
Mathias Bauer - OpenOffice.org Application Framework Project
Lead
Please reply to the list only, nospamforMBAgmx.de is
a spam sink.

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org

Hi Misael,

2006/1/11, Misael Santos <misaelgmail.com>:
>
>  Hi everybody,
>  I'm trying to access some OO objects from a Forms
(Oracle) application
> using Native OLE Automation.
>  It works fine for MS Office objects, using strings
like "Excel.Sheet", the
> OLE programmatic Identifiers.
>  The question is, how do I get the strings for
reference OO objects like a
> sheet? It's possible?

sure, OLE is just a way how the OOAPI can be accessed
(internally a
UNO-COM bridge does all the "dirty" work for you),
it does not change
the API in any way.
So you first get the service manager, from whereon you get
the
css::frame:esktop
service with the createInstance* method, the
active component and from thereon the sheets container.
Please see "3.4.3.5  Automation Bridge" in the
Developer's Guide for
background information and
http://udk.openoffice.org/common/man/tutoria
l/office_automation.html
for some useful examples.

--
Best Regards
Christian Junker

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org