OLE Excel

[Jack]

Hello ,

I have an excel sheet that is open and i want to execute a macro that is saved in an other xls file .
How to : ??
What is the syntax to Run a macro


oxls := TOleAuto():New("Excel.Application")
* Ouvre lefic3 a partir de Temp
oxls:WorkBooks:Open("main.xls")
*
oBook := oxls:Get( "ActiveWorkBook")
oSheet := oxls:Get( "ActiveSheet" )
*
oxls:visible:=.T.
*
oxls:Workbooks:Run("'FILE2.xls'!macro1") <==== ?????


Thanks
*

[Jack]

I think that Jeff Barnes is able to help me with this .

Is it ?

Thanks

Merry xMas and a Happy New Year .

[nageswaragunupudi]

oxls:Run("FILE2.xls!macro1") works.
But for me the macro is working only after I open the xls file containing the macro.