Microsoft Office Excel 2007 Visual Basic 应用进阶指南（光盘）Microsoft Office Excel 2007 Visual Basic for
点此进入淘宝搜索页搜索分类: 图书,进口原版书,计算机 Computers & Internet ,
作者： Reed Jacobson 著
出 版 社： Oversea Publishing House
出版时间： 2007-5-1字数：版次： 1页数： 354印刷时间： 2007/05/01开本： 16开印次： 1纸张： 胶版纸I S B N ： 9780735624023包装： 平装内容简介
Experience learning made easy, and quickly teach yourselfMicrosoft Office Excel 2007 Visual Basic for Applications (VBA)--one stepat a time! Work at your own pace through the easy numbered steps andpractice files on CD, and master the fundamentals for using VBA to createcustom software solutions and automating tasks in Excel 2007--no developerexperience required! You'll learn how to automate spreadsheets, write yourown functions and procedures, and customize menus and toolbars. You'lldiscover Excel Objects, including workbooks, range objects, graphics, andPivotTables-. Plus, you'll learn how to chart data from databases andother information sources. With STEP BY STEP, you can take just the lessonsyou need or work from cover to cover. Either way, you drive theinstruction--building and practicing the skills you need, just when youneed them! Includes a companion CD with hands-on practice files.
目录
About the Author
Features and Conventions of This Book
Using the Book's CD
What's on the CD?
Minimum System Requirements
Step-by-Step Exercises
2007 Microsoft Office System
Installing the Practice Files
Using the Practice Files
Removing and Uninstalling the Practice Files
Getting Help
Getting Help with This Book and Its Companion CD
More Information
1 Make a Macro Do Simple Tasks
What's the Difference Between VBA and a Macro?
Sidebar: VBA and the .NET Framework
Creating a Simple Macro
Format Currency by Using a Built-In Tool
Record a Macro to Format Currency
Run the Macro
Assign a Shortcut Key to the Macro
Look at the Macro
Save the Macro Workbook
Changing Multiple Properties at Once
Create Sidebar Headings with a Command
Record a Macro to Merge Cells Vertically
Eliminate Unnecessary Lines from the Macro
Manipulating Recorded Properties
Record a Macro to Remove Window Elements
Run the Macro from the Visual Basic Editor
Use a Macro to Toggle the Value of a Property
Eliminate Repeated Objects in a Recorded Macro
Run a Macro from the Quick Access Toolbar
Recording Methods in a Macro
Convert a Formula to a Value by Using Menu Commands
Convert a Formula to a Value by Using a Macro
Make a Long Statement More Readable
Trusting Macro-Enabled Workbooks
Designate a Trusted Location for Macros
Designate a Trusted Publisher for Macros
Key Points
2 Make a Macro Do Complex Tasks
Task One: Opening the Report File
Open a Text File
Watch a Macro Run by Stepping Through It
Select a File While Running a Macro
Task Two: Filling In Missing Labels
Select Only the Blank Cells
Fill the Selection with Values
Record Filling In the Missing Values
Watch the FillLabels Macro Run
Task Three: Adding a Column of Dates
Add a Constant Date
Step Through the Macro
Prompt for the Date
Task Four: Appending to the Database
Append Data to a Master List
Step Through the Append Data Macro
……
3 Explore Workbooks and Worksheets
4 Explore Range Objects
5 Explore Data Objects
6 Explore Graphical Objects
7 Control Visual Basic
8 Extend Excel and Visual Basic
9 Launch Macros with Events
10 Use Dialog Box Controls on a Worksheet
11 Create a Custom Form
Appendix: A Complete Enterprise Information System
Index
