Excel 2003 VBA Programming with XML and ASP (Paperback)

by Julitta Korol (Author) "Are you ready to build intelligence into your Microsoft Office Excel 2003 spreadsheets?..." (more)
Key Phrases: enter the following procedure, above statement displays, diate window, Visual Basic, End Sub, Microsoft Excel (more...)

Editorial Reviews

Product Description
Designed to provide non-programmers with a hands-on guide to automating their spreadsheets through the use of Visual Basic for Applications, Excel 2003 VBA Programming with XML and ASP also gives readers a wide range of VBA coverage and a thorough overview of a number of programming languages and techniques useful for working with Excel. Learn how to: Work with macros, write VBA procedures and functions, use object collections, and create classes. Automate operations on files, folders, and other applications such as Microsoft Office Access. Enhance the user interface through the use of dialog boxes; custom forms, menus, and toolbars; and event-driven programming. Handle errors, debug procedures, and use e-mail in Excel. Program features such as PivotTables, PivotCharts, lists, and SmartTags, and control the Visual Basic Editor. Use Excel with a number of web technologies such as HTML, ASP, and XML.

About the Author
Julitta Korol studied 10 world languages before switching her language passion to computers. Since 1993, she has delivered custom-tailored, hands-on training and automated a host of companies by developing advanced database and spreadsheet applications. She has written 16 computer books.

Product Details

• Paperback: 700 pages
• Publisher: Jones & Bartlett Publishers; 1 edition (December 27, 2005)
• Language: English
• ISBN-10: 1556222254
• ISBN-13: 978-1556222252
• Product Dimensions: 9.4 x 6 x 2 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars See all reviews (2 customer reviews)
• Amazon.com Sales Rank: #643,019 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #29 in

  Books > Computers & Internet > Databases > XML & Databases

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

4.0 out of 5 stars Very good on the whole, July 23, 2006

By	B. Gehring - See all my reviews (REAL NAME)

Still not finished, but I have been mostly very happy with the book so far. The section on automation was a key interest, and proved valuable, though I was hoping for more on the shell function, and identifying the correct string to open a wider variety of applications.

I was confused with a comment in chapter 17 concerning security popups in Outlook, that...

"When Excel attempts to send an e-mail message using Outlook, the application responds with a message to ask permission, as shown in Figure 17-12. The only way to prevent this message from coming up is by setting the macro security setting to low."

My experience to date is that digitally signing the project prevents the popups from Outlook 2003, even if the project is located in Excel. I haven't yet come to any section of the book that covers digital signatures, and the assertion that the only solution is to take the ill advised step of setting macro security to low makes me suspect that it might not be forthcoming.

Chapter 12 provided a lot of detail on interacting with Access, but some of the code seemed untested (undeclared variable and mis-spelled arguments in the two CreateTextFile subs). The chapter works as a good reference, but made for difficult reading.

Despite the above gripes, I have learned a tremendous amount from the book so far, and am anxious to come back for more. I liked the chapter on Class Modules, thought the native file handling in VBA was very well covered, learned a lot in the material on the Windows Scripting Host, and feel the text builds nicely from the basic to more involved topics. All in all one of the better VBA books I have read.

4 of 4 people found the following review helpful:

5.0 out of 5 stars Good introduction for VBA in Excel, July 29, 2007

By	S. Lam "A tech guy" (Oakland, CA United States) - See all my reviews (REAL NAME)

I started my VBA programming from zero for my department needs by using Google search. Although the job could be done, the process was time consuming (for search) and left questions unanswered.
If you want to save yourself time then this is a good book to start with. The layout is pretty good, and explain things clearly. I browsed the book but didn't read every chapter but found it's informative.
Don't expect to receive a lot of examples, but again you can find everything you need through web search.
Advance users should look for something else, like Professional Excel Development: The Definitive Guide to Developing Applications (which I owned too).
I seldom bought computer books for long time (hey, educated by web search is free) since it's expensive and out-date too quickly. This book and above are what I'm willing to invest my money in for past few years. Beside, Amazon price is very competitive.