Running Excel Macro with args

[ray306]

I can call and execute regular macros inExcel from autoIt. I have that needs to be passed a parameter and it would appear that my syntax is not correct. Code Follows:

Func runMacros() ;Runs the Macros in the Excel Workbook

With $ExcelWorkbook

.Application.Run ("StartUp")

.Application.Run ("TrainerYear")

.Application.Run ("FilterToCrit "&$rowPg2 )

EndWith

EndFunc

The first two macros run just fine. I'm trying to pass the parameter on the third and it continues to fail.

Any Ideas?

Thanks

Ray

[Locodarwin]

I can call and execute regular macros inExcel from autoIt. I have that needs to be passed a parameter and it would appear that my syntax is not correct. Code Follows:

Func runMacros() ;Runs the Macros in the Excel Workbook

With $ExcelWorkbook

.Application.Run ("StartUp")

.Application.Run ("TrainerYear")

.Application.Run ("FilterToCrit "&$rowPg2 )

EndWith

EndFunc

The first two macros run just fine. I'm trying to pass the parameter on the third and it continues to fail.

Any Ideas?

Thanks

Ray

Try this:

.Application.Run ("FilterToCrit ", $rowPg2)

You can include up to something like 20 parameters thus:

.Application.Run("Macro", $param1, $param2, $param3, ...)

-S

[ray306]

Try this:

.Application.Run ("FilterToCrit ", $rowPg2)

You can include up to something like 20 parameters thus:

.Application.Run("Macro", $param1, $param2, $param3, ...)

-S

Thanks Locodarwin

Your suggestion did the trick. I thought I had already tried that syntax but I guess not.

Thanks Again

Ray