Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Send data to excel with formated columns
Message
From
27/09/2000 13:03:49
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00421580
Message ID:
00421595
Views:
19
Hey Juan,

Could you be more specific on sending data?

Formatting is pretty easy: If oExcel is your Excel.Application object, then you could:

oExcel.ActiveSheet.Columns(1).Select
WITH oExcel.Selection
.HorizontalAlignment= -4108 && xlCenter
.BottomAlignment= -4107 && xlBottom
ENDWITH


>How can I send data from VFP to Excel and send the format of each column. P.e Alignment,Number ,etc
>
>Thanks
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform