Jump to content

Excel Integration


hemal
 Share

Recommended Posts

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

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
Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...