Excel 2007 VBA Programming with XML and ASP
- 13h 45m
- Julitta Korol
- Jones and Bartlett Learning
- 2009
Excel 2007 Programming by Example with XML and ASP offers a hands-on approach for those looking to extend and customize Excel functionality. From recording a simple macro and writing VBA code to working with XML documents and using ASP to access and display data, this book takes you on a programming journey that will change the way you work with Excel.
Learn how to:
- Automate spreadsheet tasks with macros.
- Write VBA code to program PivotTables, generate charts, build dialog boxes, and customize the Ribbon.
- Handle errors and debug programs.
- Create hyperlinks and publish HTML files.
- Retrieve data from the web directly into Excel.
- Develop and manipulate smart tags using 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. Among her titles for Wordware are Learn Microsoft Access 2003 Programming by Example with VBA, XML, and ASP, Excel 2003 VBA Programming with XML and ASP, and Access 2007 Programming by Example with VBA, XML, and ASP. She has also written a dozen computer books published exclusively by MIKOM Publishing in Warsaw, Poland. Julitta lives on Long Island, N.Y.
In this Book
-
Automating Spreadsheet Tasks with Macros
-
Exploring the Visual Basic Editor (VBE)
-
Excel VBA Fundamentals
-
Using Variables, Data Types, and Constants
-
VBA Procedures—Subroutines and Functions
-
Decision Making with VBA
-
Repeating Actions in VBA
-
Working with Arrays
-
Working with Collections and Class Modules
-
VBE Tools for Testing and Debugging
-
Conditional Compilation and Error Trapping
-
File and Folder Manipulation with VBA
-
File and Folder Manipulation with Windows Script Host (WSH)
-
Using Low-Level File Access
-
Using Excel VBA to Interact with Other Applications
-
Using Excel with Microsoft Access
-
Event-Driven Programming
-
Using Dialog Boxes
-
Creating Custom Forms
-
Formatting Worksheets with VBA
-
Shortcut Menu Programming and Ribbon Customizations
-
Printing and Sending E-mail from Excel
-
Programming PivotTables and PivotCharts
-
Using and Programming Excel Tables
-
Programming Special Features
-
Programming the Visual Basic Editor (VBE)
-
HTML Programming and Web Queries
-
Excel and Active Server Pages
-
Using XML in Excel 2007
-
Using and Programming Smart Tags
