avac Posted October 14, 2010 Share Posted October 14, 2010 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 Link to comment Share on other sites More sharing options...
daluu Posted October 14, 2010 Share Posted October 14, 2010 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. Link to comment Share on other sites More sharing options...
Wiroko Posted November 29, 2010 Share Posted November 29, 2010 I tried to implement AutoIt is Excel 2003 and i found two ways (Google is my best friend )Late bindingDim oAIX As ObjectSet oAIX = CreateObject("AutoItX3.Control")Early bindingDim oAIX As AutoItX3Set oAIX = New AutoItX3The 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now