Sign in to follow this  
Followers 0
avac

AutoItX in VBA (Excel 2007)

3 posts in this topic

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

Share this post


Link to post
Share on other sites



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.

Share this post


Link to post
Share on other sites

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

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0