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

1. Auflage 2011
ISBN: 978-1-936420-03-2
Verlag: Mercury Learning and Information

Buch, Englisch, 800 Seiten, Format (B × H): 178 mm x 229 mm, Gewicht: 1842 g

No detailed description available for "Microsoft® Excel® 2010 Programming By Example with VBA, XML, and ASP".

Autoren/Hrsg.

Korol, Julitta

Fachgebiete

• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation

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

Über Autor(innen)

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).