Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Header for Excel
Message
From
17/08/2005 12:50:41
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
17/08/2005 12:22:50
Todd Brown
Teachers Credit Union
Granger, Indiana, United States
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01041694
Message ID:
01041700
Views:
20
>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

.CenterHeader = "Company" + Chr(10) + "Report" + Chr(10) + "Date"

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform