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