June 2015
Beginner
288 pages
5h 27m
English
Chapter 4
In This Chapter
Creating a workbook
Saving a workbook when a cell is changed
Saving a workbook before you close it
Protecting and unprotecting a workbook
Opening a user-defined workbook
Determining whether a workbook is open or exists
Printing all workbooks in a directory
Creating backups of your workbook
A workbook is not just an Excel file; it's also an object in Excel's Object model (a programming hierarchy that exposes parts of Excel to VBA).
You can reference workbooks through VBA to do cool things like automatically create new workbooks, prevent users from closing workbooks, and automatically back up workbooks. In this chapter, you explore a few ...