Microsoft Excel 2000 Power Programming with VBA

3.83 avg rating
( 24 ratings by Goodreads )
 
9780764532634: Microsoft Excel 2000 Power Programming with VBA

With the latest version of Visual Basic for Applications and the new Office Component Object Model, Excel 2000 now provides an amazing platform for the development of custom spreadsheets and turnkey applications for a wide range of business needs. With the expert guidance of John Walkenbach, a leading Excel expert better known as "Mr. Spreadsheet," you'll quickly learn how to harness the full programming power of Excel 2000 -- from UserForms to class modules.

"synopsis" may belong to another edition of this title.

Review:

If you've mastered Excel and need to develop customized applications, Microsoft Excel 2000 Power Programming with VBA should have a place by your side. Written by noted Excel expert and PC World columnist John Walkenbach, it will thrust you deep into the inner workings of Excel and Visual Basic for Applications (VBA) to get you writing code immediately.

Somewhat text-heavy (as programming books tend to be), it still contains a number of good illustrations and screenshots to effectively teach you. The first three sections cover the fundamentals of Excel and VBA; the next three deal with programming and development topics such as user forms, pivot tables, and event handling; the final section covers miscellaneous issues like compatibility, file manipulation, and class modules.

The five appendices are useful for referencing Excel and VBA information, and the accompanying CD-ROM contains all the code and files you'll need to work through the book, not to mention the shareware version of Walkenbach's Power Utility Pack. (The full version is available through a free offer.) Nobody ever said programming was easy, but with Microsoft Excel 2000 Power Programming with VBA it's a lot simpler. --Rob Lightner

From the Back Cover:

Microsoft® Excel 2000 Power Programming with VBA With the latest version of Visual Basic for Applications and the new Office Component Object Model, Excel 2000 now provides an amazing platform for the development of custom spreadsheets and turnkey applications for a wide range of business needs. With the expert guidance of John Walkenbach, a leading Excel expert better known as "Mr. Spreadsheet," you'll quickly learn how to harness the full programming power of Excel 2000 — from UserForms to class modules. Take Your Spreadsheets to a Whole New Level

  • Master the overall design-development-deployment process for Excel applications
  • Take complete control of the Visual Basic Editor environment
  • Learn how to work with VBA objects, subprocedures, and functions
  • Explore basic to advanced techniques for building intuitive UserForms
  • Use VBA to develop robust Excel utilities from the ground up
  • Find out how to program Excel to respond to a wide variety of events
  • Discover how to automate charts and pivot tables in your applications
  • Create custom toolbars, menus, and help files
  • Figure out how to manipulate text files and Visual Basic Project components at design time
  • Understand what class modules are and how to use them
More than 150 example files on CD-ROM, plus a free copy of John Walkenbach's Power Utility Pak www.hungrybinds.com

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

John Walkenbach
Published by Wiley (1999)
ISBN 10: 0764532634 ISBN 13: 9780764532634
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Wiley, 1999. Paperback. Book Condition: New. Edition Unstated. Bookseller Inventory # DADAX0764532634

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 33.37
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

2.

Walkenbach, John
Published by *M&T Press (1999)
ISBN 10: 0764532634 ISBN 13: 9780764532634
New Paperback Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description *M&T Press, 1999. Paperback. Book Condition: New. Never used!. Bookseller Inventory # P110764532634

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 47.30
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

3.

Walkenbach, John
Published by *M&T Press
ISBN 10: 0764532634 ISBN 13: 9780764532634
New PAPERBACK Quantity Available: > 20
Seller:
Mediaoutlet12345
(Springfield, VA, U.S.A.)
Rating
[?]

Book Description *M&T Press. PAPERBACK. Book Condition: New. 0764532634 *BRAND NEW* Ships Same Day or Next!. Bookseller Inventory # NATARAJB1FI935024

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 51.78
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

4.

Walkenbach, John
Published by *M&T Press
ISBN 10: 0764532634 ISBN 13: 9780764532634
New PAPERBACK Quantity Available: 1
Seller:
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description *M&T Press. PAPERBACK. Book Condition: New. 0764532634 New Condition. Bookseller Inventory # NEW7.0328445

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 59.99
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

5.

John Walkenbach
Published by John Wiley & Sons
ISBN 10: 0764532634 ISBN 13: 9780764532634
New Quantity Available: 2
Seller:
Majestic Books
(London, ,, United Kingdom)
Rating
[?]

Book Description John Wiley & Sons. Book Condition: New. pp. 912. Bookseller Inventory # 7571192

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 60.88
Convert Currency

Add to Basket

Shipping: US$ 7.25
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

John Walkenbach
Published by John Wiley & Sons Inc (1999)
ISBN 10: 0764532634 ISBN 13: 9780764532634
New Paperback Quantity Available: 1
Seller:
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description John Wiley & Sons Inc, 1999. Paperback. Book Condition: Brand New. paperback/cd-rom edition. 750 pages. 9.50x7.50x2.00 inches. In Stock. Bookseller Inventory # zk0764532634

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 103.86
Convert Currency

Add to Basket

Shipping: US$ 7.91
From United Kingdom to U.S.A.
Destination, Rates & Speeds