AutoItX in VBA (Excel 2007)

[avac]

I'm having trouble implementing AutoItX in an Excel 2007 VBA script I'm working on (on Windows 7 x64 machine). Using regedit.exe, I've searched and found a reference to AutoItX3.dll, so I'm pretty sure it's registered correctly on my machine. I've tried getting the examples to work with no luck, what am I missing?

ie I've tried:

Dim oAutoIt

Set oAutoIt = WScript.CreateObject("AutoItX3.Control")

oAutoIt.Run("notepad.exe")

but I get an error 424 "Object Required"

Is there some import line I have to call? Or a reference I haven't set?

Thanks

[daluu]

No, that code should work, assuming Run is valid method (I don't use that one).

Might have to do with 64-bit. Not sure if AutoItX works under 64-bit and Windows 7. More likely problematic on 64-bit than on Windows 7.

[Wiroko]

I tried to implement AutoIt is Excel 2003 and i found two ways (Google is my best friend )

Late binding

Dim oAIX As Object

Set oAIX = CreateObject("AutoItX3.Control")

Early binding

Dim oAIX As AutoItX3

Set oAIX = New AutoItX3

The functions offered are rather limited. I wanted to use the "Ping" function in AutoIt in Excel but i have no clue .

Hope it helps,

Wiroko