Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
37 used & new from $12.99

Have one to sell? Sell yours here
 
   
Excel 2003 VBA Programming with XML and ASP
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

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...)
4.5 out of 5 stars See all reviews (2 customer reviews)

List Price: $36.95
Price: $28.08 & this item ships for FREE with Super Saver Shipping. Details
You Save: $8.87 (24%)
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Monday, July 13? Choose One-Day Shipping at checkout. Details
21 new from $21.02 16 used from $12.99

Frequently Bought Together

Customers buy this book with Access 2003 Programming by Example with VBA, XML, and ASP by Julitta Korol

Excel 2003 VBA Programming with XML and ASP + Access 2003 Programming by Example with VBA, XML, and ASP
Price For Both: $54.45

Customers Who Bought This Item Also Bought

Excel 2003 Power Programming with VBA (Excel Power Programming With Vba)

Excel 2003 Power Programming with VBA (Excel Power Programming With Vba)

by John Walkenbach
4.2 out of 5 stars (40)  $29.99
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) (Addison-Wesley Microsoft Technology Series)

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) (Addison-Wesley Microsoft Technology Series)

by Rob Bovey
4.8 out of 5 stars (28)  $37.79
VBA and Macros for Microsoft Excel (Business Solutions)

VBA and Macros for Microsoft Excel (Business Solutions)

by Bill Jelen
4.1 out of 5 stars (18)  $29.69
Excel Advanced Report Development

Excel Advanced Report Development

by Timothy Zapawa
4.6 out of 5 stars (13)  $26.39
VBA Developer's Handbook, 2nd Edition

VBA Developer's Handbook, 2nd Edition

by Ken Getz
4.4 out of 5 stars (27)  $31.49
Explore similar items

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

Inside This Book (learn more)


Books on Related Topics (learn more)
 
 

What Do Customers Ultimately Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

2 Reviews
5 star:
 (1)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.5 out of 5 stars (2 customer reviews)
 
 
 
 
Share your thoughts with other customers:
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
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]


Active discussions in related forums
  Discussion Replies Latest Post
C# or Java? 32 3 days ago
   


Product Information from the Amapedia Community

Beta (What's this?)



Look for Similar Items by Category


An Explosion of Popcorn Flavor!

Fireworks Popcorn & Seasoning Set
Munchies have never been better. The Fireworks Popcorn & Seasoning Set gives you four popcorn types and four seasonings, including white cheddar, butter burst, caramel pecan, and popcorn salt--all for $15.49.
 

Best Books of 2008

Best of 2008
Find our top 100 editors' picks as well as customers' favorites in dozens of categories in our Best Books of 2008 Store.
 

Dive into Summer Reading

Summer Reading for Kids and Teens
Don't even think about hitting the beach without browsing the books in our Summer Reading Store. Discover bestsellers, paperback picks, beach reads, and more terrific titles all summer long.
 

Free Shipping on Marpac SleepMate

Marpac Sleep Mate
Sleep tight with the Marpac SleepMate white noise machine. It's perfect for restless sleepers, children, students, apartment residents, and others. Best of all, it ships for free.

Shop now

 

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Glenn Beck's Common Sense
Glenn Beck's Common Sense
Darkfever
Darkfever by Karen Marie Moning
The Lost Symbol
The Lost Symbol by Dan Brown
$16.17

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates