Workbooks

xlWBATemplateSpecifies the type of workbook to create.
xlWindowStateSpecifies the state of the window.
xlWindowTypeSpecifies how the chart is displayed.
xlWindowViewSpecifies the view showing in the window.
xlWBATemplate
Specifies the type of workbook to create.
xlWindowState
Specifies the state of the window.
xlWindowType
Specifies how the chart is displayed.
xlWindowView
Specifies the view showing in the window.

xlWBATemplate

Specifies the type of workbook to create.

xlWBATChart-4109
xlWBATExcel4IntlMacroSheet4
xlWBATExcel4MacroSheet3
xlWBATWorksheet*-4167

xlWBATChart
-4109
xlWBATExcel4IntlMacroSheet
4
xlWBATExcel4MacroSheet
3
xlWBATWorksheet*
-4167

REMARKS
* This creates a single sheet of the specified type.

xlWindowState

Specifies the state of the window.

xlMaximized-4137
xlMinimized-4140
xlNormal-4143

xlMaximized
-4137
xlMinimized
-4140
xlNormal
-4143

xlWindowType

Specifies how the chart is displayed.

xlChartAsWindowThe chart will open in a new window (5)
xlChartInPlaceThe chart will be displayed on the current worksheet (4)
xlClipboardThe chart is copied to the clipboard (3)
xlInfoThis constant has been deprecated (-4129)
xlWorkbookThis constant applies to Macintosh only (1)

xlChartAsWindow
The chart will open in a new window (5)
xlChartInPlace
The chart will be displayed on the current worksheet (4)
xlClipboard
The chart is copied to the clipboard (3)
xlInfo
This constant has been deprecated (-4129)
xlWorkbook
This constant applies to Macintosh only (1)

xlWindowView

Specifies the view showing in the window.

xlNormalViewNormal (1)
xlPageBreakPreviewPage break preview (2)
xlPageLayoutView(Added in 2007) Page layout view (3)

xlNormalView
Normal (1)
xlPageBreakPreview
Page break preview (2)
xlPageLayoutView
(Added in 2007) Page layout view (3)


© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top