UEU-co logo

Files and Software on the CD


Previous Page

Next Page

Files and Software on the CD

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:

  • .xlsx: An Excel workbook file.

  • .xlsm: An Excel workbook file that contains VBA macros.

  • .xlam: An Excel add-in file that contains VBA macros.

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 Image from book 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

  • Image from book sample.xlsm: A sample file used to demonstrate the file structure of an Excel workbook.

CHAPTER 6

CHAPTER 7

CHAPTER 8

  • Image from book timing test.xlsm: A workbook that demonstrates the speed advantage of declaring variables as a specific data type.

CHAPTER 9

CHAPTER 10

  • Image from book array argument.xlsm: A workbook that contains an example of a function that uses an array argument.

  • Image from book commission functions.xlsm: A workbook that contains an example of a function that uses an argument.

  • Image from book draw.xlsm: A workbook that contains a function that selects a cell randomly.

  • Image from book key press.xlsm: A workbook that uses an API function to determine if the Ctrl, Shift, or Alt key is pressed.

  • Image from book month names.xlsm: A workbook that demonstrates returning an array from a function.

  • Image from book mysum function.xlsm: A workbook that contains a function that simulates Excel’s SUM function.

  • Image from book no argument.xlsm: A workbook that contains functions that don’t use an argument.

  • Image from book remove vowels.xlsm: A workbook that contains a function that removes the vowels from its argument.

  • Image from book upper case.xlsm: A workbook that contains a function that converts text to uppercase.

  • Image from book win32api.txt: A text file that contains Windows API declarations and constants.

  • Image from book windows directory.xlsm: A workbook that uses an API function to determine the Windows directory.

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

  • cell comments: A directory that contains a workbook that demonstrates using cell comments to display help information.

  • function help: A workbook that demonstrates how to display help for custom VBA worksheet functions.

  • html help: A directory that contains files that demonstrate using compiled HTML help.

  • mhtml file: A directory that contains files that demonstrate using an MHTML file to display help information in Internet Explorer.

  • textbox: A directory that contains a workbook that demonstrates using a text box to display help information.

  • userform1: A directory that contains a workbook that demonstrates using a UserForm with a SpinButton control to display help information.

  • userform2: A directory that contains a workbook that demonstrates using a UserForm with a scrolling Label control to display help information.

  • userform3: A directory that contains a workbook that demonstrates using a UserForm with a ComboBox control to display help information.

  • web browser: A directory that contains files that demonstrate using a UserForm to display help information.

  • worksheet: A directory that contains a file that demonstrates using a worksheet to display help information.

CHAPTER 25

CHAPTER 26

CHAPTER 27

CHAPTER 28

CHAPTER 29

  • Image from book csv class.xlsm: A workbook that makes it easy to import and export a CSV file.

  • Image from book keyboard class.xlsm: A workbook that contains a class module that defines a NumLock, a CapsLock, and a ScrollLock class.

CHAPTER 30

Previous Page

Next Page

Leave a Reply


Time limit is exhausted. Please reload the CAPTCHA.

Categories

apply_now Pepperstone Group Limited