hemal 1 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 Share this post Link to post Share on other sites
exodius 1 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. Share this post Link to post Share on other sites
PsaltyDS 27 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 Share this post Link to post Share on other sites
