Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating an Excel function to access VFP data
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00845807
Message ID:
00845816
Views:
12
>Is it possible to create a dll with VFP that can be called as a function from Excel? I'd like to develop an Excel function that will access VFP data and return a specific VFP data value to an Excel cell.
>
>Can someone point me to some sample code if this is possible?
>

Joel,
See MSKB#214260 for some information about creating custom functions in Excel. Yes you can use the VBA syntax to create a VFP COM object, pass it the necessary parameters and have it return what you want. Depending on the speed of you PC, the overhead to create the object may not be noticable to your users.

HTH.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform