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.
Book Description
Frequently Bought Together
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
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,
This review is from: Excel 2003 VBA Programming with XML and ASP (Windows Programming Developmnt) (Paperback)
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,
By
Amazon Verified Purchase(What's this?)
This review is from: Excel 2003 VBA Programming with XML and ASP (Windows Programming Developmnt) (Paperback)
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.
5.0 out of 5 stars
Very Thorough,
By
This review is from: Excel 2003 VBA Programming with XML and ASP (Windows Programming Developmnt) (Paperback)
I bought this book to help me figure out how to read an xml file and collect certain data to populate a spreadsheet. It was quite helpful for that and also helped me understand more about file access in general. There is a lot more here that I have not studied yet.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
Are you ready to build intelligence into your Microsoft Office Excel 2003 spreadsheets? Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
enter the following procedure, above statement displays, diate window, brand new workbook, following procedure prints, numl variable, following function procedure, run the above procedure, specified workbook, user shifts the focus, worksheet menu bar, chart workspace, creating user forms, timesheet data, workbook file, macro dialog box, workbook events, macro workbook, smart tag button, enter the following statement, writing event procedures, active menu bar, smart tag lists, type the following statement, following example procedure Key Phrases - Capitalized Phrases (CAPs): (learn more)
Visual Basic, End Sub, Microsoft Excel, Microsoft Access, Microsoft Office, Project Explorer, Private Sub, Object Browser, Program Files, Exit Sub, Select Case, Resume Next, Event Description Example, Info Survey, End Function, Property Get, End If Next, Option Explicit, End Select, Cancel Figure, File Edit View Insert, Microsoft Word, Internet Explorer, Select Selection, Data Objects New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Are you ready to build intelligence into your Microsoft Office Excel 2003 spreadsheets? Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
enter the following procedure, above statement displays, diate window, brand new workbook, following procedure prints, numl variable, following function procedure, run the above procedure, specified workbook, user shifts the focus, worksheet menu bar, chart workspace, creating user forms, timesheet data, workbook file, macro dialog box, workbook events, macro workbook, smart tag button, enter the following statement, writing event procedures, active menu bar, smart tag lists, type the following statement, following example procedure Key Phrases - Capitalized Phrases (CAPs): (learn more)
Visual Basic, End Sub, Microsoft Excel, Microsoft Access, Microsoft Office, Project Explorer, Private Sub, Object Browser, Program Files, Exit Sub, Select Case, Resume Next, Event Description Example, Info Survey, End Function, Property Get, End If Next, Option Explicit, End Select, Cancel Figure, File Edit View Insert, Microsoft Word, Internet Explorer, Select Selection, Data Objects New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Books on Related Topics
(learn more)
|
|
What Other Items Do Customers 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.
|
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 Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
