Free Shipping in Australia on over 5 million books in stock
Microsoft Excel 2010 Programming By Example By Julitta Korol

Microsoft Excel 2010 Programming By Example

Used Price
77,99 $
inc. GST
Free Shipping in Australia
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 introduces programming concepts of Excel. It provides information on performing automatic operations on files, folders, and other Microsoft Office applications.

Only 1 left


Microsoft Excel 2010 Programming By Example Summary


Microsoft Excel 2010 Programming By Example by Julitta Korol

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.

Customer Reviews - Microsoft Excel 2010 Programming By Example


Why buy from World of Books

Our excellent value books literally don't cost the earth
Free delivery in Australia
Read more here
Every used book bought is one saved from landfill

About Julitta Korol


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

Table of Contents


  • 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

Additional information

GOR005796570
Microsoft Excel 2010 Programming By Example by Julitta Korol
Julitta Korol
Used - Very Good
Hardback
Mercury Learning & Information
2011-03-11
800
1936420031
9781936420032
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us.