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.

Was this article helpful?

0 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook

Post a comment