O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Workbook and Workbooks Members

Use the Workbooks collection to create new and open existing workbooks in Excel. Use the Application object’s Workbooks method to get a reference to this collection. Use the Workbook object to save and control individual workbooks. The Workbooks collection and Workbook object have the following members. Key members (shown in bold) are covered in the following reference section:

Tip

Password and protection members are covered in Chapter 26.

1 Collection only

2 Object and collection

AcceptAllChanges

AcceptLabelsInFormulas

Activate

ActiveChart

ActiveSheet

Add 1

AddToFavorites

Application 2

Author

AutoUpdateFrequency

AutoUpdateSaveChanges

BreakLink

BuiltinDocumentProperties

CalculationVersion

CanCheckIn

CanCheckOut 1

ChangeFileAccess

ChangeHistoryDuration

ChangeLink

Charts

CheckIn

CheckOut 1

Close 2

CodeName

Colors

CommandBars

Comments

ConflictResolution

Container (obsolete)

Count 1

CreateBackup

Creator 2

CustomDocumentProperties

CustomViews

Date1904

DeleteNumberFormat

DialogSheets (obsolete)

DisplayDrawingObjects

DisplayInkComments

DocumentLibraryVersions

EnableAutoRecover

EndReview

EnvelopeVisible

Excel4IntlMacroSheets

Excel4MacroSheets ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required