Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling functions in excel modules
Message
 
To
20/11/2003 15:45:15
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00852064
Message ID:
00852074
Views:
8
This message has been marked as the solution to the initial question of the thread.
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()
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform