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