Thanks Yuri. It works.
>Try:
>objExcel.Application.Run("MyFunc")
>
>>Hi all,
>>
>>I have an Excel file with a Module containing a function, say: Public Function MyFunc(). How do I call this from VFP if at all possible. I don't have a problem calling the function from within Excel.
>>
>>Assuming oXLS is my excel object, so far these does not run:
>>
>>oXLS.Modules(1).MyFunc()
>>oXLS.Workbooks.Modules(1).MyFunc()
>>oXLS.Module1.MyFunc()
>>oXLS.MyFunc()
>>
ramil
~~ learning to stand still