hemal Posted August 30, 2010 Share Posted August 30, 2010 How can i integrate Excel with autoit script.I want to run .au3 file / .au3 code or compiled .exe from Excel VBA.Is it possible ? / HOW ??Thanks,HeMaLhttp://hemal.mp Link to comment Share on other sites More sharing options...
exodius Posted August 30, 2010 Share Posted August 30, 2010 This isn't an Excel VBA forum, do some Google searching and you'll come up with something like this: http://www.mrexcel.com/archive/VBA/11775.html If you want to run a .au3 file you need to run the core "C:\Program Files\AutoIt3\AutoIt3.exe" file and pass it your .au3 file as an argument. Link to comment Share on other sites More sharing options...
PsaltyDS Posted August 30, 2010 Share Posted August 30, 2010 (edited) From VBA you can run Shell(Command, WinState), where Command = full commandline, and WinState = how the spawned shell window is displayed. WinState Values: vbHide 0 Window is hidden and focus is passed to the hidden window. vbNormalFocus 1 Window has focus and is restored to its original size and position. vbMinimizedFocus 2 Window is displayed as an icon with focus. vbMaximizedFocus 3 Window is maximized with focus. vbNormalNoFocus 4 Window is restored to its most recent size and position. The currently active window remains active. vbMinimizedNoFocus 6 Window is displayed as an icon. The currently active window remains active. If the script is compiled to an .exe you can run it directly with the full path. If it's an uncompiled script you have to run AutoIt3.exe (as exodius already posted). I haven't tested it, but you might be able run .Shell() as method off the $oExcel.Application object with the AutoIt Excel.au3 UDF. Edited August 30, 2010 by PsaltyDS Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law 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