[Solved] Create Uno Service DDE

[matheuslage]

Hello,

I'm trying to get DDE data from open office basic and my object come Null,

Dim oDDE as Object

oDDE = CreateUnoService( "com.sun.star.sheet.DDELink" )
oDDE = CreateUnoService( "com.sun.star.sheet.DDELinks" )
oDDE = CreateUnoService( "com.sun.star.sheet.DDELinksEnumeration" )

i try get com.sun.star.container.XNamed (only exemple to try remove my Object of NULL)
i think that i dont know the correct address i need use.


I'm trying create one script in basic that i get the same data of function =DDE("xxx";"xxx";"xxxxxx") return to me,
but i dont want get this data from cell, i want generate this function (=DDE("xxx";"xxx";"xxxxxx")) in basic.

If somebody know how solve it , i will be grateful.

[Lupp]

I would assume a DDELink service can only exist as an element of the DDELinks property (container) of a spreadsheet document.
Therefore neiter the "general context" nor the document can create it, but it must be added to the container on creation.
See https://api.libreoffice.org/docs/idl/re ... Links.html (e.g.)

Code: Select all

Sub example
doc = ThisComponent REM a spreadsheet document
ddeLks = doc.DDELinks
myLink = ddeLks.addDDELink(arg1, arg2, arg3, arg4)
REM Arguments need to be valid instances of the appropriate types.
End Sub

Disclaimer: I never created a working DDELink this way.

[matheuslage]

tksss, it worked for me!

exactly what i need,

I am so gratefull