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()
>