Workbook Methods:   Return to List

' workbk is a reference to a particular workbook

workbk.Activate' determines the active workbook
Workbooks.Add' adds a new, empty, workbook
workbk.Close' closes the workbook
workbk.Open "filename"' opens the specified file
workbk.Save' saves the workbook
workbk.SaveAs "filename"' as above, but under the given name
workbk.SaveCopyAs "filename"' saves a copy without changing the name of the workbook
workbk.Name' contains the file name (without path)
workbk.Path' contains the path only
workbk.FullName' contains the entire filename (including path)
workbk.Saved' tells whether the workbook has been saved

See also:
Built-In Dialogs and Argument Lists
Closing a Workbook (with options)
Create new Workbook from Worksheet
Deleting a Workbook (i.e., File)
Filename of the active Workbook (full path/name)
File Open Dialog (for browsing and selecting files)
File SaveAs Dialog (for saving files)
Opening a Workbook (known filename)
Saving a Workbook without Dialogs



Note to Webmaster