Microsoft® Excel® 2010 Programming By Example with VBA, XML, and ASP

Informationen zum Autor Since 1993, Julitta Korol has published two dozen computer books on using and programming Microsoft Excel and Microsoft Access. She has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA). Klappentext "Microsoft Excel 2010 Programming by Example with VBA, XML and ASP" is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. Thirty chapters loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed. This title includes thirty chapters loaded with illustrated hands-on projects and exercises that demonstrate programming concepts. Each exercise/project tells you exactly where to enter code and how to debug it and then run it. It includes a comprehensive CD-ROM with tips, shortcuts, and tutorials. It is updated for Excel 2010 and based on the bestselling editions from previous versions. It uses the Excel built-in Visual Basic development environment and its numerous tools. It manipulates and formats worksheet data programmatically. It provides rich user experience with dialog boxes, custom forms, ribbon design, and the proper use of event procedures. Learn to perform automatic operations on files, folders and MS Office applications. Test your procedures with debugging tools, and write custom error handling code. Program advanced Excel features such as PivotTables, PivotCharts, and SmartTags. Harness the power of XML and ASP. Zusammenfassung A practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. Inhaltsverzeichnis 1) Automating Worksheet Tasks with Macros 2) Exploring the Visual Basic Editor (VBE) 3) Excel VBA Fundamentals 4) Using Variables, Data Types, and Constants 5) VBA Procedures: Subroutines and Functions 6) Decision Making with VBA 7) Repeating Actions in VBA 8) Working with Arrays 9) Working with Collections and Class Modules 10) VBE Tools for Testing and Debugging 11) Conditional Compilation and Error Trapping 12) File and Folder Manipulation with VBA 13) File and Folder Manipulation with Windows Script Host (WSH) 14) Using Low-Level File Access 15) Using Excel VBA to Interact with Other Applications 16) Using Excel with Microsoft Access 17) Event-Driven Programming 18) Using Dialog Boxes 19) Creating Custom Forms 20) Formatting Worksheets with VBA 21) Context Menu Programming and Ribbon Customizations 22) Printing and Sending E-mail from Excel 23) Programming PivotTables and PivotCharts 24) Using and Programming Excel Tables 25) Programming Special Features 26) Programming the Visual Basic Editor (VBE) 27) HTML Programming and Web Queries 28) Excel and Active Server Pages 29) Using XML in Excel 2010 30) Calling Windows API Functions from VBA Index...

Autorentext

Korol Julitta:
Since 1993, Julitta Korol has published two dozen computer books on using and programming Microsoft Excel and Microsoft Access. She has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).

Klappentext

"Microsoft Excel 2010 Programming by Example with VBA, XML and ASP" is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. Thirty chapters loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed. This title includes thirty chapters loaded with illustrated hands-on projects and exercises that demonstrate programming concepts. Each exercise/project tells you exactly where to enter code and how to debug it and then run it. It includes a comprehensive CD-ROM with tips, shortcuts, and tutorials. It is updated for Excel 2010 and based on the bestselling editions from previous versions. It uses the Excel built-in Visual Basic development environment and its numerous tools. It manipulates and formats worksheet data programmatically. It provides rich user experience with dialog boxes, custom forms, ribbon design, and the proper use of event procedures. Learn to perform automatic operations on files, folders and MS Office applications. Test your procedures with debugging tools, and write custom error handling code. Program advanced Excel features such as PivotTables, PivotCharts, and SmartTags. Harness the power of XML and ASP.

Zusammenfassung
A practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects.

Inhalt

1) Automating Worksheet Tasks with Macros
2) Exploring the Visual Basic Editor (VBE)
3) Excel VBA Fundamentals
4) Using Variables, Data Types, and Constants
5) VBA Procedures: Subroutines and Functions
6) Decision Making with VBA
7) Repeating Actions in VBA
8) Working with Arrays
9) Working with Collections and Class Modules
10) VBE Tools for Testing and Debugging
11) Conditional Compilation and Error Trapping
12) File and Folder Manipulation with VBA
13) File and Folder Manipulation with Windows Script Host (WSH)
14) Using Low-Level File Access
15) Using Excel VBA to Interact with Other Applications
16) Using Excel with Microsoft Access
17) Event-Driven Programming
18) Using Dialog Boxes
19) Creating Custom Forms
20) Formatting Worksheets with VBA
21) Context Menu Programming and Ribbon Customizations
22) Printing and Sending E-mail from Excel
23) Programming PivotTables and PivotCharts
24) Using and Programming Excel Tables
25) Programming Special Features
26) Programming the Visual Basic Editor (VBE)
27) HTML Programming and Web Queries
28) Excel and Active Server Pages
29) Using XML in Excel 2010
30) Calling Windows API Functions from VBA

Index