Excel Integration

[hemal 1]

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,

HeMaL

http://hemal.mp

[exodius 1]

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.

[PsaltyDS 39]

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