Wattle Software - producers of XMLwriter XML editor
 Bookstore Home | XMLwriter Home | Search | Site Map 
XML Related
 General XML
 XSLT & Stylesheets
 XHTML
 SGML
 XML DTDs
 XML Schema
Web Development
 Web Graphics
 HTML
 Dynamic HTML
Web Services
 General Web Services
 UDDI
 SOAP
 WSDL
 Programming/Scripting 
 PHP Programming
 Perl Programming
 Active Server Pages
 Java Server Pages
 JavaScript
 VBScript
 .NET Programming
 
XMLwriter
 About XMLwriter
 Download XMLwriter
 Buy XMLwriter
XML Resources
 XML Links
 XML Training
 The XML Guide
 XML Book Samples
 

Learn Microsoft Excel 2000 VBA Programming


By Julitta Korol
 
Image of: Learn Microsoft Excel 2000 VBA Programming
Pricing Details:

List Price:$39.95
You save:-- (--)
Your Price:Currently Unavailable
Buy Now

Book Details:

Format:Paperback, 445 pages.
Publisher:Wordware Publishing 2000-01
ISBN:1556227035

Average Customer Rating:

3.5 3.5 out of 5 stars (3 reviews)

Editorial Reviews:

Learn Microsoft Excel 2000 VBA Programming leads you through the process of creating VBA procedures from start to finish with detailed, practical ?how-to? examples and plenty of illustrations. You?ll learn how to:

Take advantage of the built-in macro recorder to speed up repetitive spreadsheet tasks and learn essential VBA commands and statements.

Control many features of Microsoft Excel with objects, properties, and methods.

Write subroutines and functions from scratch.

Add decision-making to your procedures with If?Then, If?Then?Else, and other statements.

Use looping structures to repeat statement sequences in your code.

Manage lists and tables of data with arrays.

Manipulate files and folders programmatically using VBA statements and functions.

Control other applications from Excel through DDE and Automation.

Create and customize user forms by following the sample applications.

Modify the user interface by creating your own menus and toolbars.

Learn how to handle errors and debug your programs by using watch expressions and breakpoints.

The companion CD contains all VBA procedures and supplementary files used in the book?s exercises.

Learn Microsoft Excel 2000 VBA Programming teaches you how to get the most from the world?s most popular spreadsheet by utilizing its powerful built-in tool?the Visual Basic for Applications (VBA) programming language. If you?ve already mastered the fundamentals of Excel, it?s time to move forward and learn Excel?s secret weapon. With VBA you can delegate many tedious tasks to Excel and execute them later with just the press of a button. You can produce fully automatic and flexible spreadsheet solutions for yourself or others.


Customer Reviews:

2 out of 5 stars Good topics--poor coverage

My review is based on Chapter 8, Manipulating files and folders with VBA.

I'd say the author's approach to writing this chapter is equivalent to identifying a few of the VBA commands related to files, and copying the on-line help. These commands are the older ones like CurDir, Name, Dir, MkDir and RmDir. She does not describe the FSO (File System Object) Library that is the centerpiece of Kofler's treatment of this subject.

There is no imagination here, no sense of real problems that occur in solving a real problem. The on-line help is as useful as the book, and also as useless. There are even fewer examples of code than the on-line help provides. And in trying to cobble together a complete project, there is no additional help here. The problems you cannot solve with the on-line help are not solved by Julitta.

A further annoyance is the Wordware Publishing binding, which will not open flat, so you have to pin it between your legs and the desk to kee!p it open at the page you are consulting while you type in the examples.

Bottom Line: Wait for a better book, or put up with the out-of-date Elizabeth Boonin. If you can understand a more advanced approach, go for Kofler's "Definitive Guide to Excel VBA", which really treats the newer features of Excel VBA.

4 out of 5 stars Good style and explanation of subject, let down by errors

A very good book for self teaching on Excel VBA, flawed by mistakes in the text. At least in spotting the errors,I improved my understanding of the subject. Ho hum.

4 out of 5 stars An Excellent Book for the Beginner and Intermediate Programm

I found this book to be easy to understand with plenty inside information on programming Excel. There are lots of tutorials which use most of the features of programming in Excel. The CD-ROM with all the tutorial exercises is useful for the longer exercises. It is slightly marred by a few typos.


Find similar books by category...


Search for more:

Search books:  



Google
 
Web XMLwriter.net




Last updated: Sat Nov 22 8:05:30 CST 2008
© Wattle Software 2007. All rights reserved.