Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Header for Excel
Message
De
17/08/2005 12:22:50
Todd Brown
Teachers Credit Union
Granger, Indiana, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Titre:
Header for Excel
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows NT
Database:
Visual FoxPro
Divers
Thread ID:
01041694
Message ID:
01041694
Vues:
70
I want to have it look like this:
Company Name
Report
Date

When it prints. I cannot figure out how to turn "& chr(10) &" into the correct code in VFP.

Thanks
Todd

With oSheet.ActiveSheet.PageSetup
.CenterHeader = "Company Name - Report - Date"
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
* .LeftMargin = Application.InchesToPoints(0.33)
* .RightMargin = Application.InchesToPoints(0.34)
* .TopMargin = Application.InchesToPoints(1)
* .BottomMargin = Application.InchesToPoints(1)
* .HeaderMargin = Application.InchesToPoints(0.5)
* .FooterMargin = Application.InchesToPoints(0.5)
.PrintHeadings = .T.
.PrintGridlines = .T.
.PrintQuality = 600
.CenterHorizontally = .T.
.CenterVertically = .F.
.Orientation = 2
.Draft = .T.
.PaperSize = 5
.Zoom = .F.
.FitToPagesWide = 4
.FitToPagesTall = 1
EndWith
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform