Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Reports to Excel
Message
From
13/01/2004 12:12:34
 
 
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00866392
Message ID:
00866397
Views:
19
Check in the download section for frx2any, plus you can write your own program to do that.

* 1. Launch Excel via OLE-Automation.
oExcel = createobject("excel.application")

* 2. Create a new workbook.
oWorkbook = oExcel.Workbooks.Add()
oSheet=oExcel.ActiveSheet()

oSheet.Cells(1,4).Value=DATE()
oSheet.Cells(1,2).Value="Normal Report"
oSheet.Cells(1,2).Font.Size=20
oSheet.cells(1,2).font.bold=.T.

oExcel.Application.Visible = .T.

This is just a sample,

HTH

>Is there an OCX out there that will take a VFP Report output to Excel?
>
>Thanks in Advance!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform