Workbooks Properties

Name

Returns

Description

Item

Workbook

Read-only. Returns a single Workbook object from the Workbooks collection based on a given Index parameter specifying an index number or a name

Workbooks Methods

Name

Returns

Parameters

Description

Add

Workbook

[Template]

Adds a new workbook to the collection. Using a template name in the Template parameter can specify a template. Also, the XlWBATemplate constants can be used to open up a type of workbook

CanCheckOut

Boolean

Filename As String

Returns whether Excel can check out a specified workbook from a server

Name

Returns

Parameters

Description

Checkout

Filename As String

Returns a specified workbook

from a server for editing

Close

Closes the workbook

open

Workbook

Filename As String,

Opens a workbook specified by

[UpdateLinks],

the Filename parameter and

[Readonly],

adds it to the collection. Use the

[Format],

UpdateLinks parameter to

[Password],

choose how links in the file are

[WriteRes

updated. Set Readonly to True

Password],

to open up the workbook in

[IgnoreRead-only

read-only mode. If the file

Recommended],

requires a password, use the

[Origin],

Password or WriteResPassword

[Delimiter],

parameters. Set AddToMru to

[Editable],

True to add the opening

[Notify],

workbook to the recently used

[Converter],

files list.

[AddToMru],

If the file to open is a delimited

[Local],

text file, then there are some

[CorruptLoad]

parameters that can be used.

Use the Format parameter to

choose the text delimiter charac-

ter if opening a text file. Use the

Origin parameter to choose the

code page style of the incoming

delimited text file. Use the

Delimiter parameter to spec

ify a delimiter if 6 (custom) was

chosen for the Format parameter

openDatabase

Workbook

Filename As

Returns a Workbook

String,

representing a database

[CommandText],

specified by the Filename

[CommandType],

parameter. The CommandText

[Background Query],

and CommandType parameters

[ImportData As]

set the text and the type of the

Returns

Parameters

Description

OpenText

OpenXML

Workbook

Filename As String, [Origin], [StartRow], [DataType], [Text Qualifier], [Consecutive Delimiter], [Tab],

[Semicolon], [Comma], [Space], [Other], [OtherChar], [FieldInfo], [TextVisual Layout] , [Decimal Separator] [Thousands Separator], [Trailing MinusNumbers], [Local]

Filename As String,

[Stylesheets],

[LoadOption]

Opens the text file in Filename and parses it into a sheet on a new workbook. Origin is used to choose the code page style of the file (XlPlatform constant). StartRow decides the first row to parse. DataType decides if the file is xlDelimited or xlFixedWidth. Set ConsecutiveDelimiter to True to treat consecutive delimiters as one. Set Tab, Semicolon, Comma, Space, or Other to True to pick the delimiter character. Use the DecimalSeparator and ThousandsSeparator to pick the numeric characters to use

Returns an XML file in Microsoft Excel. Use the Stylesheets parameter to specify which XSLT stylesheet processing instructions to apply

Was this article helpful?

0 0

Post a comment