get existed COM

ruby

hi, sys.COM is most useful, but it seems that it always create a new instance of COM, right?

how to connect to existed COM?

for example, if Excel is currently running already, how to connect to it?

something like GetObject of VBA:
[Login to see the link]

[Login to see the link]

Samir

Hi Ruby,

It's a very good Idea. I will see what it's possible to do.

ruby

I found that for office, (Excel, Word)
sys.COM("Word.Application") will start a new process by using parameters:
winword.exe /automation -embedding
or
excel.exe /automation -embedding

and normally it is only winword.exe or excel.exe, without any parameter.

but today I found that, for another software, not of Microsoft,
though sys.COM("other.Application") still start a new process by using parameters:
other.exe /automation -embedding

but when there is an existed process of other.exe with no parameter, it CAN connect to it.

and if connect again, then it started another process, by using parameters:
other.exe /automation -embedding.

why not office work like this?

Samir

I think each COM object decide how it will be "launched" : either a new instance or a currently running instance.
The sys.COM object don't have any choice on this : the Windows system decide how to create a new COM instance, depending on how the COM object is registered certainly

Samir

Ok I've found a way to implement the equivalent of Visual Basic GetObject for LuaRT, to force using an existing running instance of a COM object.

It will be available in next LuaRT release