Excel Printing Objects

CustomView (1997) Represents a custom workbook view. The CustomView object is a member of the CustomViews collection.

Application
Creator
Delete()
Name
Parent
PrintSettings
RowColSettings
Show()

CustomViews (1997) A collection of custom workbook views. Each view is represented by a CustomView object.

Add(ViewName, [PrintSettings], [RowColSettings])
Application
Count
Creator
GetEnumerator()
Item(ViewName)
Parent

DefaultWebOptions (2000) Contains global application-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page. You can return or set attributes either at the application (global) level or at the workbook level. (Note that attribute values can be different from one workbook to another, depending on the attribute value at the time the workbook was saved.) Workbook-level attribute settings override application-level attribute settings. Workbook-level attributes are contained in the WebOptions object.

AllowPNG [= setting]
AlwaysSaveInDefaultEncoding [= setting]
Application
CheckIfOfficeIsHTMLEditor [= setting]
Creator
DownloadComponents [= setting]
Encoding [= setting]
FolderSuffix
Fonts
LoadPictures [= setting]
LocationOfComponents [= setting]
OrganizeInFolder [= setting]
Parent
PixelsPerInch [= setting]
RelyOnCSS [= setting]
RelyOnVML [= setting]
SaveHiddenData [= setting]
SaveNewWebPagesAsWebArchives [= setting]
ScreenSize [= setting]
TargetBrowser [= setting]
UpdateLinksOnSave [= setting]
UseLongFileNames [= setting]

Filter (2000) Represents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range.

Application
Creator
Criteria1
Criteria2
On
Operator
Parent

Filters (2000) A collection of Filter objects that represents all the filters in an autofiltered range.

Application
Count
Creator
GetEnumerator()
Item
Parent

Graphic (2002) Contains properties that apply to header and footer picture objects.

Application
Brightness [= setting]
ColorType [= setting]
Contrast [= setting]
Creator
CropBottom [= setting]
CropLeft [= setting]
CropRight [= setting]
CropTop [= setting]
Filename [= setting]
Height [= setting]
LockAspectRatio [= setting]
Parent
Width [= setting]

HPageBreak (1997) Represents a horizontal page break. The HPageBreak object is a member of the HPageBreaks collection.

Application
Creator
Delete()
DragOff(Direction, RegionIndex)
Extent
Location [= setting]
Parent
Type [= setting]

HPageBreaks (1997) The collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.

Add(Before)
Application
Count
Creator
GetEnumerator()
Item
Parent

PageSetup (1995) Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.

Application
BlackAndWhite [= setting]
BottomMargin [= setting]
CenterFooter [= setting]
CenterFooterPicture
CenterHeader [= setting]
CenterHeaderPicture
CenterHorizontally [= setting]
CenterVertically [= setting]
ChartSize [= setting]
Creator
Draft [= setting]
FirstPageNumber [= setting]
FitToPagesTall [= setting]
FitToPagesWide [= setting]
FooterMargin [= setting]
HeaderMargin [= setting]
LeftFooter [= setting]
LeftFooterPicture
LeftHeader [= setting]
LeftHeaderPicture
LeftMargin [= setting]
Order [= setting]
Orientation [= setting]
PaperSize [= setting]
Parent
PrintArea [= setting]
PrintComments [= setting]
PrintErrors [= setting]
PrintGridlines [= setting]
PrintHeadings [= setting]
PrintNotes [= setting]
PrintQuality [= setting]
PrintTitleColumns [= setting]
PrintTitleRows [= setting]
RightFooter [= setting]
RightFooterPicture
RightHeader [= setting]
RightHeaderPicture
RightMargin [= setting]
TopMargin [= setting]
Zoom [= setting]

PublishObject (2000) Represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the PublishObject object. The PublishObject object is a member of the PublishObjects collection.

Application
AutoRepublish [= setting]
Creator
Delete()
DivID
Filename [= setting]
HtmlType [= setting]
Parent
Publish([Create])
Sheet
Source
SourceType
Title [= setting]

PublishObjects (2000) A collection of all PublishObject objects in the workbook. Each PublishObject object represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the object.

Add(SourceType, Filename, [Sheet], [Source], [HtmlType], [DivID], [Title])
Application
Count
Creator
Delete()
GetEnumerator()
Item
Parent
Publish()

Style (1995) Represents a style description for a range. The Style object contains all style attributes (font, number format, alignment, and so on) as properties. There are several built-in styles, including Normal, Currency, and Percent. Using the Style object is a fast and efficient way to change several cell-formatting properties on multiple cells at the same time.

AddIndent [= setting]
Application
Borders
BuiltIn
Creator
Delete()
Font
FormulaHidden [= setting]
HorizontalAlignment [= setting]
IncludeAlignment [= setting]
IncludeBorder [= setting]
IncludeFont [= setting]
IncludeNumber [= setting]
IncludePatterns [= setting]
IncludeProtection [= setting]
IndentLevel [= setting]
Interior
Locked [= setting]
MergeCells [= setting]
Name
NameLocal
NumberFormat [= setting]
NumberFormatLocal [= setting]
Orientation [= setting]
Parent
ReadingOrder [= setting]
ShrinkToFit [= setting]
Value
VerticalAlignment [= setting]
WrapText [= setting]

Styles (1995) A collection of all the Style objects in the specified or active workbook. Each Style object represents a style description for a range. The Style object contains all style attributes (font, number format, alignment, and so on) as properties. There are several built-in styles  including Normal, Currency, and Percent  which are listed in the Style name box in the Style dialog box (Format menu).

Add(Name, [BasedOn])
Application
Count
Creator
GetEnumerator()
Item
Merge(Workbook)
Parent

VPageBreak (1997) Represents a vertical page break. The VPageBreak object is a member of the VPageBreaks collection.

Application
Creator
Delete()
DragOff(Direction, RegionIndex)
Extent
Location [= setting]
Parent
Type [= setting]

VPageBreaks (1997) A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.

Add(Before)
Application
Count
Creator
GetEnumerator()
Item
Parent

WebOptions (2000) Contains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page. You can return or set attributes either at the application (global) level or at the workbook level. (Note that attribute values can be different from one workbook to another, depending on the attribute value at the time the workbook was saved.) Workbook-level attribute settings override application-level attribute settings. Application-level attributes are contained in the DefaultWebOptions object.

AllowPNG [= setting]
Application
Creator
DownloadComponents [= setting]
Encoding [= setting]
FolderSuffix
LocationOfComponents [= setting]
OrganizeInFolder [= setting]
Parent
PixelsPerInch [= setting]
RelyOnCSS [= setting]
RelyOnVML [= setting]
ScreenSize [= setting]
TargetBrowser [= setting]
UseDefaultFolderSuffix()
UseLongFileNames [= setting]