Mastering Excel 2003 Programming with VBA

"Create Powerful Business Applications with Excel 2003

Excel 2003 is an ideal application development platform for all levels of business needs. If you're an advanced Excel user looking to gain programming experience, or a skilled developer new to Excel or the Excel Object Model, this no-nonsense book teaches you how to build custom applications that can generate substantial time and cost savings for you, your employer, and your customers.

Written by a professional with nearly a decade of experience producing Excel/VBA solutions, Mastering Excel 2003 Programming with VBA conveys the precise knowledge and techniques you need to be highly productive. You'll master the most critical Excel objects and development practices necessary to create a complete solution, including working with XML data, Smart Document technology, and database integration with ADO. And you can readily apply the practical advice and reusable code examples to your own projects.

In his friendly style, author Steven Hansen makes the information easy to grasp and entertaining to read, and he does not shy away from challenging material.

You'll learn all about:

Ramping up with VBA
Debugging tools and tactics that work
Mastering the Excel Object Model
Developing class modules
Customizing Excel UserForms
Integrating Excel with other applications
Incorporating text files in your solution
Coding solutions that leverage a database
Using XML in Excel
Designing user-friendly toolbars and menus
Building Excel 2003 Smart Documents
Deploying your solution

Share your thoughts on the Mastering Excel 2003 Programming with VBA ebook with other internet viewers!

Title of ebook: Mastering Excel 2003 Programming with VBA
ISBN: 9780782151053
parent-ISBN: 9780782142815
Publisher: Sybex
Internet download file size: 16414 kb
Pages: 608
Published: 07-2006
Released online for download: 07-14-2006
Author of eBook: Hansen, Steven M.

Format

Encrypted

Sku

ISBN

File size

Security

Printing

Copying

Read aloud

Devices

Digital Editions

Yes

0782151051

9780782151053

16414 KB

n/a

Not allowed

15 selections to your clipboard every 365 days

Sys Requirments

Download reader

Mastering Excel 2003 Programming with VBA

Chapter One

Excel as a Development Platform

I often find myself explaining what it means when I say I am an Excel developer. People have heard of Java developers, C/C++ developers, Visual Basic developers, web developers, and many other various technologies that people develop in, but an Excel developer?

This chapter introduces you to what it means to be an Excel developer and why Microsoft Excel makes such an interesting and useful development platform for many types of applications.

Who Develops in Excel?

When I was younger, I remember wanting to be many different things: a dolphin trainer, a professional hockey player, and a pilot, to name a few. I also went through a phase when I thought it would be cool to be a programmer (except as a kid I wanted to develop games, not boring business programs). Then I grew up and my priorities changed. In fact, in my first "real" career job, I was a financial analyst. At no point in my life did I plan on becoming an Excel developer; it just happened. The factors that drove me to become one are interesting and, I believe, quite common in the corporate world.

First, most analysts, and many other "knowledge workers" for that m ... read full excerpt from Mastering Excel 2003 Programming with VBA ebook

Share your thoughts on the Mastering Excel 2003 Programming with VBA ebook with other internet viewers!

Title: Mastering Excel 2003 Programming with VBA
Avg. Customer Review: 4 out of 5 stars

Number Of Comments:
1 Rating(s)

Other Computers eBooks Categories

Computers General (1564)

Artificial Intelligence (34)

Business Software (633)

Certification (341)

Computer Graphics (1059)

Computer Science (38)

Data Transmission Sys (106)

Database Mgmt (713)

Electronic Commerce (85)

Electronic Publishing (260)

Hardware (530)

Information Technology (165)

Internet (868)

Security (62)

Web Site Design (299)

Miscellaneous Software (40)

Networking (882)

Operating Sys (910)

Programming (2452)

Reference (212)

Security (197)

Top eBooks in Business Software

Business Knowledge for IT in Prime Brokerage
by Essvale Corporation Limited

Prime brokerage is booming .As their hedge fund clients cast their net over a wider geographical area in search of superior returns by opening offices in new ...more

Best price: $55.71

ACT! by Sage For Dummies
by Fredricks, Karen S.

What the book covers: ACT! For Dummies, 9th edition shows new users how to use the ACT! contact management/CRM software for ACT! ...more

Best price: $21.92

Crystal Xcelsius for Dummies
by Alexander, Michael

As the fastest growing dashboarding solution on the market, Xcelsius is an intuitive stand-alone Windows application that enables excel users to ...more

Best price: $26.45

Business Analysis with Microsoft Excel
by Carlberg, Conrad

Take control of the bottom line using expert techniques and excel's powerful financial capabilities! Whether you own a small business or work for a large ...more

Best price: $27.60

Crystal Reports XI : The Complete Reference
by Peck, George

This best-seller has been fully updated for Crystal Reports XI (extreme insight) -- the first jointly developed release of this leading report writing and ...more

Best price: $54.33

Architecture and Patterns for IT Service Management, Resource Planning, and Governance: Making Shoes for the Cobbler's Children
by Betz

"This book unveils a great model that managers and executives can use to maximize their technology investment. It develops an action plan for managing all ...more

Best price: $43.92

Xcelsius® 2008 Dashboard Best Practices

Customer review:
Comprehensive book with lots of examples. easy to understand...more

Best price: $30.75

SAP Business Objects Interview Questions: Business Objects in SAP Analyt

Customer review:
SAP BO is a very helpful book which gives you insight of what new with BO and reporting side in sap... It is a very good book for preparing for interviews...more

Best price: $54.95

Sams Teach Yourself SAP R/3 in 24 Hours

Customer review:
I used this book to approch to SAP Universe. It has been usefull and I suggest it to beginners...more

Best price: $19.10

Mastering Excel 2003 Programming with VBA

Chapter One

People who bought "Mastering Excel 2003 Programming with VBA" ebook also bought: