Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using FoxPro from withing Excel w/o FoxPro?
Message
From
13/01/2003 12:36:01
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Title:
Using FoxPro from withing Excel w/o FoxPro?
Miscellaneous
Thread ID:
00741056
Message ID:
00741056
Views:
56
Is it possible to use VFP 7 from within Excel without actually installing VFP on the target machine?

I'm using syntax similar to the following:

Dim oFox As Object
Set oFox = CreateObject("VisualFoxPro.Application")

oFox.DoCmd "SELECT line_no,b_l,gl,units,shipper as shipcode,pro_no,corp,name as carrier,batch_no as batch ,line_no as Line, " + _
" (Fas_val+ex_value+fuel_app+insur_app+gst_app)" _
+ " as Amount,gst_app as gst,weight as actual_wt, bweight as billed_wt, bill_date, supplier as customer, locname as destcity, " _
+ "supplier.prov as destprov " _
+ " from &mfile bills,&supFile supplier,f:\test\carrier carrier where batch_no = " + Workbooks("personalmacros.xls").Worksheets("sheet1").Range("c7") + _
" and consignee = supplier.code and carrier = carrier.code order " + _
"by name,batch_no,line_no into cursor batch1 "

... etc.

I know the SBT product has a "simulated Dot Prompt" and I'm wondering if there is anything along those lines that might work?

Thanks in advance for any assistance.
On a CLEAR day you can see forever.
Next
Reply
Map
View

Click here to load this message in the networking platform