title | keywords | f1_keywords | ms.service | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|---|
Application.FilePageSetupHeader method (Project) |
vbapj.chm2357 |
|
project-server |
|
e41ff9e1-d656-14fe-3d81-deef3065d11d |
06/08/2017 |
medium |
Sets up headers for printing.
expression. FilePageSetupHeader
( _Name_
, _Alignment_
, _Text_
)
expression A variable that represents an Application object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
Name | Optional | String | The name of the view or report for which to set up headers for printing. |
Alignment | Optional | Long | The alignment of the text in the header. Can be one of the following PjAlignment constants: pjLeft, pjCenter, or pjRight. The default value is pjCenter. |
Text | Optional | String | The text to display in the header. The following special format codes may be included as part of the header: |
Format Code | Description |
---|---|
&B | Turns bold printing on or off. |
&I | Turns italic printing on or off. |
&U | Turns underline printing on or off. |
&""fontname"" | Prints characters that follow the format code in the specified font. An example would be &""Arial"". |
&nn | Prints characters that follow the format code in the specified font size. Use a two-digit number to specify a size in points. An example would be &08. |
&P""path"" | Inserts the specified image. An example would be &P"" [My Documents] \Image.gif"". The term [My Documents] represents the full path to your My Documents folder. |
&[Date] | Prints the current system date. |
&[Time] | Prints the current system time. |
&[File] | Prints the file name. |
&[Page] | Prints the page number. |
&[Pages] | Prints the total number of pages in the document. |
&[Project Title] | Prints the title. |
&[Company] | Prints the company name. |
&[Manager] | Prints the manager name. |
&[Start Date] | Prints the project start date. |
&[Finish Date] | Prints the project finish date. |
&[Current Date] | Prints the project current date. |
&[Status Date] | Prints the project status date. |
&[View] | Prints the view name. |
&[Report] | Prints the report name. |
&[Filter] | Prints the filter name. |
&[Saved Date] | Prints the last saved date. |
&[Subject] | Prints the subject. |
&[Author] | Prints the author. |
&[Keyword] | Prints the keyword(s). |
&[ Field_Name ] | Prints the value of the field specified with Field_Name. If a macro will be run in more than one language, the field specified with Field_Name must use the name localized for each language. An example would be &[Actual Cost]. |
|
Boolean
Using the FilePageSetupHeader method without specifying any arguments displays the Page Setup dialog box with the Header tab selected.
The following example sets up a header for printing.
Sub SetLegend()
Dim strLegend As String
strLegend = GetFontFormatCode("Arial")
strLegend = strLegend & "&BThis text will appear in the legend.&B"
Application.FilePageSetupLegend Text:=strLegend, _
Alignment:=pjCenter, LegendOn:=pjOnEveryPage
End Sub
Public Function GetFontFormatCode(strFontName As String) As String
GetFontFormatCode = "&" & Chr(34) & strFontName & Chr(34)
End Function
[!includeSupport and feedback]