Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Formatting ...
Message
From
12/10/2001 13:48:09
 
 
To
09/10/2001 16:56:40
Melvin Sequera
M&H New World, C.A.
Fuenlabrada, Spain
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00566207
Message ID:
00567820
Views:
15
Here are some samples

With oleExcel
.Application.cells.font.name="Arial"
.Cells(1,1).Font.Bold =.T.
.Cells(1,1).Font.Underline =.T.
.Cells(1,1).Font.Size =.T.

.COLUMNS(1).NUMBERFORMAT = "$#,##0.00_);[Red]($#,##0.00)"

.ActiveSheet.PageSetup.LeftFooter="&6 "+DTOC(DATE())+" "+TIME()
ENDWITH
I hope this helps
Jerry R
Previous
Reply
Map
View

Click here to load this message in the networking platform