Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

The following sections provide more details about the software and other materials available on the CD.

eBook version of Excel 2007 Power Programming with VBA

The complete text of the book you hold in your hands is provided on the CD in Adobe's Portable Document Format (PDF). You can read and quickly search the content of this PDF file by using Adobe's Acrobat Reader, also included on the CD.

Sample files for Excel 2007 Power Programming with VBA

The files discussed in the book are organized by chapter. With a few exceptions, the files are all Excel 2007 files that have one of the following extensions:

When you open an XLSM file, Excel may display a security warning that tells you that macros have been disabled. To enable macros, click the Options button in the security warning panel and then select Enable This Content.

Because the files on this CD are from a trusted source, you may want to copy the files to your hard drive and then designate the folder as a trusted location. To do so, follow these steps:

  1. Open an Explorer window and double-click the CD-ROM drive that contains the companion CD-ROM.

  2. Right-click the folder that corresponds to the root folder for the samples files and select Copy from the shortcut menu.

  3. Activate the folder on your hard drive where you'd like to copy the files. Right-click the directory and choose Paste from the shortcut menu.

The CD-ROM files will be copied to a subfolder in the folder you specified in Step 3.

To designate this new folder as a trusted location:

  1. Start Excel and choose Office Excel Options to display the Excel Options dialog box.

  2. In the Excel Options dialog box, click the Trust Center tab.

  3. Click the Trust Center Settings button.

  4. In the Trust Center dialog box, click the Trusted Locations tab.

  5. Click the Add New Location button to display the Microsoft Office Trusted Location dialog box.

  6. In the Microsoft Office Trusted Location dialog box, click the Browse button and locate the folder that contains the files copied from the CD-ROM.

  7. Make sure you select the option labeled Subfolders of This Location Are Also Trusted.

After performing these steps, when you open XLSM files from this location, the macros are enabled and you don't see the security warning.

Following is a list of the sample files, along with a brief description.

Note  

Some chapters don't use any sample files.

CHAPTER 3

CHAPTER 4

CHAPTER 6

CHAPTER 7

CHAPTER 8

CHAPTER 9

CHAPTER 10

CHAPTER 11

CHAPTER 12

CHAPTER 13

CHAPTER 14

CHAPTER 15

CHAPTER 16

CHAPTER 17

CHAPTER 18

CHAPTER 19

CHAPTER 20

CHAPTER 21

CHAPTER 22

CHAPTER 23

CHAPTER 24

CHAPTER 25

CHAPTER 26

CHAPTER 27

CHAPTER 28

CHAPTER 29

CHAPTER 30

Категории