In this chapter you saw many techniques for handling workbooks and worksheets in VBA code. You have seen how to:

□ Create new workbooks and open existing workbooks.

□ Handle saving workbook files and overwriting existing files.

□ Move and copy worksheets and interact with Group mode.

You have also seen that you access some workbook and worksheet features through the Window object, and have been shown that you can synchronize your worksheets using workbook events procedures. See Chapter 9 for more discussion on this topic.

In addition, a number of utility macros have been presented, including routines to check that a workbook is open and to extract a filename from the full file path, and a simple macro that confirms that a file does indeed exist.

0 0

Post a comment