I lose COM connection saving and loading the script.

[Sscratchie]

Latest PMC, Excel 14 32 bit, Win 10.

This breaks when I load the macro. Clicking the Connect button in the COM interface fixes it. I've tried different COM commands and they all fail.

Code: Select all

WinActivate, Microsoft Excel - Book1.xlsm
Sleep, 333
If (!IsObject(XL))
    XL := ComObjCreate("Excel.Application")
XL.Range("D1").Select

I thought AHK was awesome before I worked out COM. I understand why 0.1% people use Office now. Can't figure out why the rest of them do.

[Pulover]

You must change the command to ComObjActive() to connect to the last active window. This can be changed in export options.

[Sscratchie]

Thanks. Solved

Code: Select all

If (!IsObject(XL))
    XL := ComObjCreate("Excel.Application")
XL := ComObjActive("Excel.Application")

It's the first time I've worked with a currency with 12 decimal places.
Monero Wallet to Quickbooks via dos shell, Bash shell, Excel, VB and AHK tying it together

[Peter_g]

Excuse me, may I ask you, what do 99.9% of people use instead of Office?

[Sscratchie]

I've never seen an incoming email to Outlook create a new account in an accounting package or add/change fields in an Excel spreadsheet.
Everybody uses Office but doesn't use the extended functionality provided by VB and COM.
I've never seen AHK anywhere but where I used to work and no-one there knew it was AHK making the F keys do stuff.