Pro Excel 2007 VBA

By: Jim DeMarco

Write A Review

Paperback | 2 August 2011

At a Glance

Paperback
388 Pages

Dimensions(cm)
23.5 x 17.78 x 1.91

Paperback

$47.29

or 4 interest-free payments of $11.82 with

Ships in 5 to 7 business days

This is a professionals' guide to understanding and implementing the key principles and techniques of programming Microsoft Office Excel 2007. Automating complex spreadsheets, streamlining time-intensive work processes, gaining the competitive edge, and making more money for your businesses: these are all reasons to take Excel to the next level. This book teaches how to do just that, with the author using his own real-life experience to develop the readers' understanding to this professional level. The text teaches the most efficient way to create complex and feature rich VBA code, exposing all the new features and capabilities that make Excel 2007 so exciting. The Excel book market is a multi-million dollar industry with rival 'expert' guides in VBA programming commanding market share as high as 3% for an individual title. The depth and excellence of Apress' Pro series' treatment of this subject allows it to go head-to-head with the best of these rivals.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Object-Oriented Programming or OOP Business Applications Spreadsheet Software Microsoft Excel Software Engineering Microsoft Programming Programming & Scripting Languages

About the Author	p. xi
About the Technical Reviewer	p. xiii
Acknowledgments	p. xv
Introduction	p. xvii
The Macro Recorder and Code Modules	p. 1
Macro Security Settings	p. 1
Trusted Publishers	p. 2
Trusted Locations	p. 2
The Remove Button	p. 3
Lowering the Security Level	p. 3
The Visual Basic Development Environment	p. 4
The Immediate Window	p. 10
The Locals Window	p. 11
The Watch Window	p. 13
Recording a Macro	p. 14
Formatting the Table	p. 16
Adding Totals	p. 17
Same Task, Different Code	p. 18
Writing a Macro in the VBE	p. 20
More Macro Security	p. 21
The Object Browser	p. 24
Object Browser Window Elements	p. 25
Standard Code Modules	p. 27
Subprocedures	p. 28
Functions	p. 28
Type Statements	p. 29
Class Modules	p. 29
Sample Class and Usage	p. 31
The Class-y Way of Thinking	p. 35
UserForms	p. 36
Toolbox Window Elements	p. 37
Object-Oriented Programming: An Overview	p. 39
OOP: Is It Worth the Extra Effort?	p. 40
Summary	p. 41
Data In, Data Out	p. 43
Excel's Data Import Tools	p. 43
Importing Access Data	p. 43
Simplifying the Code	p. 46
Importing Text Data	p. 48
Macro Recorder-Generated Text Import Code	p. 51
Using DAO in Excel 2007	p. 54
Importing Access Data Using Jet	p. 55
Importing Access Data Using ODBC	p. 60
Importing SQL Data Using ODBC	p. 65
Using ADO in Excel 2007	p. 67
Importing SQL Data	p. 67
Importing SQL Data Based on a Selection	p. 75
Updating SQL Data	p. 80
Of Excel, Data, and Object Orientation	p. 87
Using the cExcelSetup and cData Objects	p. 95
Summary	p. 96
Using XML in Excel 2007	p. 99
Importing XML in Excel 2007	p. 99
Appending XML Data	p. 106
Saving XML Data	p. 107
Building an XML Data Class	p. 108
A Final Test	p. 117
Adding a Custom Ribbon to Your Workbook	p. 119
Inside the Excel 2007 XML File Format	p. 119
Viewing the XML	p. 120
Adding a Ribbon to Run Your Custom Macros	p. 128
Summary	p. 132
UserForms	p. 133
Creating a Simple Data Entry Form	p. 133
Designing the Form	p. 133
The Working Class	p. 139
Coding the UserForm	p. 143
Creating Wizard-Style Data Entry UserForms	p. 150
Laying Out the Wizard Form	p. 152
Adding Controls to the Form	p. 154
HRWizard Classes	p. 160
The HRWizard Business Objects	p. 161
Managing Lists	p. 169
The Data Class	p. 169
Managing the Wizard	p. 172
Coding the HRWizard UserForm	p. 178
Summary	p. 191
Charting in Excel 2007	p. 193
Getting Started	p. 193
Looking at the Code	p. 198
Summarizing with Pie Charts	p. 202
Creating the Pie Chart	p. 206
More Pie for Everyone	p. 211
Dynamically Placing a Chart	p. 216
Summary	p. 221
PivotTables	p. 223
Putting Data into a PivotTable Report	p. 223
The Macro Code	p. 229
Refreshing Data in an Existing PivotTable Report	p. 235
Applying Formatting to a PivotTable Report	p. 238
Summary	p. 247
Debugging and Error Handling	p. 249
Debugging	p. 249
The Debugger's Toolkit	p. 249
Quick Debugging	p. 253
A Deeper Look	p. 261
Error Handling	p. 275
Is the File There?	p. 275
Trapping Specific Errors	p. 278
Summary	p. 285
Office Integration	p. 287
Creating a Report in Word	p. 287
The Helper Functions	p. 290
Creating an Instance of Word	p. 291
Adding Charts to the Report	p. 295
Creating a PowerPoint Presentation	p. 298
Coding the Presentation	p. 299
Summary	p. 314
ActiveX and .NET	p. 315
Using ActiveX Components in Your Excel 2007 Projects	p. 315
Are There Any Benefits?	p. 316
Custom Functionality with ActiveX	p. 316
Excel in the .NET World	p. 323
Managed Code in an Excel Project	p. 327
Summary	p. 350
Index	p. 351
Table of Contents provided by Ingram. All Rights Reserved.

Pro Excel 2007 VBA

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Spreadsheet Software

Microsoft 365 Excel For Dummies

For Dummies (Computer/Tech)

Microsoft 365 Excel All-in-One For Dummies

Excel for Dummies

Microsoft Power BI Step by Step

Microsoft Excel 365 Bible

Bible

Excel Dashboards & Reports For Dummies

4th edition

Microsoft Power BI Dashboards Step by Step

Step by Step

Modern Data Analytics in Excel

Using Power Query, Power Pivot and More for Enhanced Data Analytics

Financial Modeling in Excel For Dummies

2nd edition

Financial Analysis with Microsoft Excel

9th edition

Microsoft 365 Excel VBA Programming For Dummies

For Dummies (Computer/Tech)

Statistics for Ecologists Using R and Excel, 2nd edition : Data Collection, Exploration, Analysis and Presentation

Data in the Wild

Python for Excel

A Modern Environment for Automation and Data Analysis

Statistics for Managers Using Microsoft Excel, Global Edition

9th Edition

Accounting Information Systems

5th Edition - Controls and Processes

Python in Excel Step-by-Step

Problem Solving Cases In Microsoft Access & Excel

16th edition

The Definitive Guide to DAX 2nd edition

Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI

Microsoft Power BI Visual Calculations

Simplifying DAX

Microsoft Excel VBA and Macros

Your guide to efficient automation

The New Frontier of Excel Analysis and Reporting with Excel Array Formulas and LET & LAMBDA Functions

Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight

Upgrade Your Excel with Python

A Practical Guide for Nonprogrammers

Microsoft Copilot Studio Step by Step

Customizing Copilot and creating agents

Python in Excel

Unlocking powerful data analysis and automation solutions

GitHub Copilot Step by Step

Navigating AI-driven software development

This product is categorised by