how to run macro using autoit

[gauravvogue]

hi.. i have two queries

1... How to run macro using autoit?

I have used the below code but its giving error as unable to parse line......is that the right code ? I am opening a macro file name"Tmacro" saved in C drive folder named Market

 

$oExcel = ObjCreate("Excel.Application")
$oExcel.WorkBooks.Open($C:MarketTmacro.xlsm)
$oExcel.Run("Macro1")
"more code"

 

2. Whenever the macro execution gets completed then i want to execute further commands in my autoit script and dont want to use sleep function?????? please help

[water]

Needs to be:

$oExcel.WorkBooks.Open("C:\Market\Tmacro.xlsm")

[water]

Doesn't "Run" wait until the called macro has finished? So you simply call "Run" multiple times in your AutoIt script.

[gauravvogue]

hi

i have used the below command to open my excel macro file

_ExcelBookOpen ("C:MarketTmacro.xlsm")( getting successful)

 

but can u tell me how would i run my macro from here... as i have used

.Run("Macro1")  but it is showing an error as object referenced outside a "with " statement

[water]

$oExcel = _ExcelBookOpen ("C:\Market\Tmacro.xlsm")
$oExcel.Run("Macro1")
$oExcel.Run("Macro2")
...

Edited February 19, 2014 by water

[gauravvogue]

thanks sir!

It was getting successful. Just one last query

How can i program that" I want to wait until the macro gets finished"........?

actually i dont want to include" SLEEP command"..................

 

sometimes macro run 30 seconds and sometimes 50 seconds......

[water]

MSDN says: "The Run method returns whatever the called macro returns"

So I think the AutoIt script will wait until the macro has finished and then processes the next statement.