Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing Parent-Child Records to Excell
Message
From
05/09/2006 09:32:42
David Shedd
Memphis Police Department
Memphis, Tennessee, United States
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01150914
Message ID:
01150916
Views:
28
I am using Office automation from VFP

* Put column headings in Row 5
.Range("B6").Value = "Deposit Reciept#"
.Range("C6").Value = "Description"
.Range("D6").Value = "Deposit Date"
.Range("E6").Value = "Check #"
.Range("F6").Value = "Debit"

oRange = .Range("B7:G7")
ENDWITH

* Loop through orders and send data
SCAN
WITH oRange
.Columns[1].Value = ALLTRIM(Deposit_number)
.Columns[2].Value = ALLTRIM(Released_to)
.Columns[3].Value = DTOC(Deposit_date)
.Columns[4].Value = Check_number
.Columns[5].Value = Debit

ENDWITH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform