Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling functions in excel modules
Message
From
20/11/2003 22:13:41
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00852064
Message ID:
00852193
Views:
8
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
Previous
Reply
Map
View

Click here to load this message in the networking platform