Control via COM an already open Excel

[Jekko]

Hello, i have this issue

Code: Select all

oExcel := ComObjCreate("Excel.Application") 
oExcel.Workbooks.Add 
oExcel.Visible := 1

With these lines of code i can open a new Excel instance and control it via the COM.
BUT
if an excel application is ALREADY open (with an active sheet), how could assign that istance to a COM object in order to control it via AHK?

Thank you for the replies

[jeeswg]

Try this:
Excel_Get - AutoHotkey Community
https://autohotkey.com/boards/viewtopic.php?f=6&t=31840

[FanaticGuru]

You can also try just using the command made for it:
xlApp := ComObjActive("Excel.Application")

This will work for most people. It is all I ever use and I use COM with Excel alot on several different computers.

The Excel_Get function is more robust and can handle some fringe cases.

FG

[Jekko]

Thank you very much.

ComObjActive for now is enough for me, if i will detect further problems i will pass to Excel_Get()

Jekko