Running an excel macro from within AutoIt

[mikep56]

Hi All,

I have been struggling to figure out how to run an Excel macro on an Excel spreadsheet from an AutoIt script. I have looked over the forum and the help files without success.

Thanks for any help that can be tossed my way.

Regards,

Mike

[PsaltyDS]

Hi All,

I have been struggling to figure out how to run an Excel macro on an Excel spreadsheet from an AutoIt script. I have looked over the forum and the help files without success.

Thanks for any help that can be tossed my way.

Regards,

Mike

Is it associated with a hotkey? Might be as easy as ControlSend() the hotkey to the Excel window.

[mikep56]

Hi PsaltyDS,

The macro is launched by pressing a smiley face button that I placed on the toolbar that is associated with the macro. However, being in VB or VBS or VBA (I can't remember which), shouldn't the macro be launchable from an AutoIt script command. Right now I am using the mouse commands to click on the smiley face.

Thanks for your help.

regards,

Mike

[ptrex]

@all

Maybe this can help you out.

switches for Excel

You can use a command line switch /m to activate a makro.

Option 2 is this : Run Excel Macros through Automation

regards

ptrex

Edited October 19, 2007 by ptrex

[PsaltyDS]

@all

Maybe this can help you out.

switches for Excel

You can use a command line switch /m to activate a makro.

Option 2 is this : Run Excel Macros through Automation

regards

ptrex

The references on Option 2 imply that you can only do four specific built-in macros that way: xlAutoActivate, xlAutoClose,

xlAutoDeactivate, and xlAutoOpen. Does that work with ad hoc macros of your own?

[mikep56]

Hi All,

After some deep internet searching, I found this simple way. Open the PERSONAL.XLS file in Excel. Right click the sheet1 tab at the bottom and select View Code. In the Project box on the left, click on ThisWorkbook. Then at the top left pulldown select Workbook, and type in Run "name of macro" between Private Sub Workbook_Open() and End Sub. Make sure that the macro name is in quotes. Then click on File, Save Personal.XLS. The next time you open Excel, the macro will run.

Good luck and thanks again to all in this forum who helped.

Regards,

Mike

[ptrex]

@PsaltyDS

Yes works fine for any macro.

; AutoRun Macro

Dim $objXL

$objXL = ObjCreate("Excel.Application")
  
    With $objXL.Application
        .Visible = True
        ;Open the Workbook
        .Workbooks.Open ("C:\Test.xls")
        $x = .Run("Test") ; MacroName, Parameters1, Parameter2, ...
    EndWith

Regards

ptrex

[PsaltyDS]

@PsaltyDS

Yes works fine for any macro.

; AutoRun Macro

Dim $objXL

$objXL = ObjCreate("Excel.Application")
  
    With $objXL.Application
        .Visible = True
        ;Open the Workbook
        .Workbooks.Open ("C:\Test.xls")
        $x = .Run("Test") ; MacroName, Parameters1, Parameter2, ...
    EndWith

Regards

ptrex

Coolness!

Thanks for the tip.

[ptrex]

@PsaltyDS

You're welcome !!

See you around.

regards,

ptrex