Poetry Madness
 
 

Recently Viewed clear list


Interviews | April 8, 2014

Shawn Donley: IMG Gabrielle Zevin: The Powells.com Interview



Gabrielle ZevinThe American Booksellers Association collects nominations from bookstores all over the country for favorite forthcoming titles. The Storied Life of... Continue »
  1. $17.47 Sale Hardcover add to wish list

    The Storied Life of A. J. Fikry

    Gabrielle Zevin 9781616203214

spacer

On Order

$54.99
New Trade Paper
Currently out of stock.
Add to Wishlist
Qty Store Section
- Local Warehouse Personal Computers- Desktop Applications- Spreadsheets

Definitive Guide To Excel Vba 2ND Edition

by

Definitive Guide To Excel Vba 2ND Edition Cover

 

Synopses & Reviews

Publisher Comments:

New in the second editon: Covers Excel 2000 to 2003 Explains how to access Web Services from Excel programs Shows you how to process lists and XML data with Excel 2003

Microsoft's Excel is not only a powerful spreadsheet and graphics toolit contains a programming language called Visual Basic for Applications (VBA), which allows you to automate simple tasks and enables you to create full-featured applications that make Excel users even more productive. In the Definitive Guide to Excel VBA, Second Edition, veteran author Michael Kofler provides exhaustive coverage of VBA for Excel, demonstrating how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it also covers advanced topics needed for users already familiar with VBA.

First, Kofler introduces VBA and the Excel object model, focusing on the unique characteristics of programming and debugging code associated with spreadsheets. The next few chapters cover menus, toolbars, forms, and templatesthe tools for creating customized user interfaces and full-featured applications. He then moves on to a broad range of advanced topics, including automating graphs and diagrams, accessing external databases from Excel, and analyzing data using grouping and pivot-tables. He even covers ActiveX automation and the access of Web Services using the Web Service Toolkit.

Throughout the book, Kofler never loses sight of the real-world problems faced by Excel programmers. The book also explores ways to avoid undocumented problems that may arise when programming Excel VBA?practical knowldege that was gained through years of hard experience.

Synopsis:

Kofler provides the definitive coverage of VBA for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it nevertheless covers advanced topics needed for users already familiar with VBA.

Synopsis:

This book is definitive. Though assuming no knowledge of VBA or Visual Basic, it covers every aspect of Excel programming. The emphasis is always on solving problems that professionals will encounter in their daily work. Whether it is automatically displaying different views of data through pivot tables or accessing databases through ADO, the latest Microsoft database technology, it's all here. The final chapter provides a reference on Excel objects that is equally definitive. It is important to note that this book is not an advertising brochure for Excel. If there are problems with the Excel object library (and unfortunately there are many of them), they are explained. Whenever possible, Kofler explains a work-around. Still, this book gives the reader a comprehensive look at what you can do with Excel - and despite some problems, the range of possible applications is huge.

Synopsis:

Microsoft's Excel is not only a powerful spreadsheet and graphics tool, it contains a programming language called Visual Basic for Application (VBA). VBA allows you to automate simple tasks, but also enables you to create full-featured applications that make Excel users more productive. In Definitive Guide to Excel VBA, Second Edition, Michael Kofler provides the definitive coverage VBA for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it nevertheless covers advanced topics needed for users already familiar with VBA.

Table of Contents

Writing Your First Macro.- What's New in Excel 2000.- The Development Environment.-VBA Concepts.- Techniques of Programming.- Debugging, Protection When Errors Arise.-Forms (MS Forms Library).- Menus and Toolbars.- Templates, Smart Forms.- Charts and Drawing Objects (Shapes).- Data Management in Excel.- Access to External Data.- Data Analysis in Excel.- VBA Programming for Pros, Office Developer.- Object Reference.

Product Details

ISBN:
9781590591031
Author:
Kofler, Michael
Publisher:
Apress
Author:
Kofler
Subject:
Programming - General
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Computer software
Subject:
Computer software -- Development.
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Edition Number:
2
Edition Description:
New
Series:
Definitive Guide to
Publication Date:
20030731
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
936
Dimensions:
9.20x7.06x1.83 in. 3.22 lbs.

Other books you might like

  1. Microsoft Word Version 2002 Inside... Used Trade Paper $9.50
  2. Delphi for .Net Developer's Guide Used Trade Paper $9.95
  3. Mastering Borland Delphi 2005 New Trade Paper $53.95
  4. Practical SQL Handbook 4TH Edition... Used Trade Paper $34.00
  5. Programming Microsoft Visual Basic... New Trade Paper $59.99
  6. Excel 2002 Power Programming with... Used Trade Paper $3.98

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Computers and Internet » Software Engineering » Programming and Languages

Definitive Guide To Excel Vba 2ND Edition New Trade Paper
0 stars - 0 reviews
$54.99 Backorder
Product details 936 pages Apress - English 9781590591031 Reviews:
"Synopsis" by , Kofler provides the definitive coverage of VBA for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it nevertheless covers advanced topics needed for users already familiar with VBA.
"Synopsis" by , This book is definitive. Though assuming no knowledge of VBA or Visual Basic, it covers every aspect of Excel programming. The emphasis is always on solving problems that professionals will encounter in their daily work. Whether it is automatically displaying different views of data through pivot tables or accessing databases through ADO, the latest Microsoft database technology, it's all here. The final chapter provides a reference on Excel objects that is equally definitive. It is important to note that this book is not an advertising brochure for Excel. If there are problems with the Excel object library (and unfortunately there are many of them), they are explained. Whenever possible, Kofler explains a work-around. Still, this book gives the reader a comprehensive look at what you can do with Excel - and despite some problems, the range of possible applications is huge.
"Synopsis" by , Microsoft's Excel is not only a powerful spreadsheet and graphics tool, it contains a programming language called Visual Basic for Application (VBA). VBA allows you to automate simple tasks, but also enables you to create full-featured applications that make Excel users more productive. In Definitive Guide to Excel VBA, Second Edition, Michael Kofler provides the definitive coverage VBA for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it nevertheless covers advanced topics needed for users already familiar with VBA.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.