FiveTech Support Forums

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
*

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

Is it ?

Thanks

Merry xMas and a Happy New Year .

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