Microsoft Office Excel 2007 Visual Basic 应用进阶指南（光盘）Microsoft Office Excel 2007 Visual Basic for 下载 pdf 百度网盘 epub 免费 2025 电子书 mobi 在线

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

暂无相关内容，正在全力查找中

暂无出版社相关信息，正在全力查找中！

暂无相关书籍摘录，正在全力查找中！

在线阅读地址：Microsoft Office Excel 2007 Visual Basic 应用进阶指南（光盘）Microsoft Office Excel 2007 Visual Basic for在线阅读

在线听书地址：Microsoft Office Excel 2007 Visual Basic 应用进阶指南（光盘）Microsoft Office Excel 2007 Visual Basic for在线收听

在线购买地址：Microsoft Office Excel 2007 Visual Basic 应用进阶指南（光盘）Microsoft Office Excel 2007 Visual Basic for在线购买

暂无原文赏析，正在全力查找中！

书籍介绍

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.