Sign in to follow this  
Followers 0
hemal

Excel Integration

3 posts in this topic

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

post-6288-1283166872421_thumb.jpg

Share this post


Link to post
Share on other sites



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

#3 ·  Posted (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 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

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