Excel 2007 VBA Macro Programming

Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
Cover of the book Excel 2007 VBA Macro Programming by Richard Shepherd, McGraw-Hill Companies,Inc.
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Richard Shepherd ISBN: 9780071627016
Publisher: McGraw-Hill Companies,Inc. Publication: November 1, 2009
Imprint: McGraw-Hill Osborne Media Language: English
Author: Richard Shepherd
ISBN: 9780071627016
Publisher: McGraw-Hill Companies,Inc.
Publication: November 1, 2009
Imprint: McGraw-Hill Osborne Media
Language: English
Develop custom Excel VBA macros Perfect for power users, this practical resource reveals how to maximize the features and functionality of Excel 2007. You'll get in-depth details on Excel VBA programming and application development followed by 21 real-world projects--complete with source code--that show you how to set up specific subroutines and functions. The book then explains how to include the subroutines in the Excel menu system and transform a set of interrelated VBA macros into an Excel add-in package. Create your own Excel 2007 VBA macros right away with help from this hands-on guide. Excel 2007 VBA Macro Programming shows you how to: Write and debug VBA code Create custom dialog boxes and buttons Maximize the Excel object model Write code to interact with a database Add functionality to your programs with API calls Insert class modules Develop custom menus for the Ribbon Animate objects in Excel Create and manipulate Pivot Tables in VBA Expand calculation and search functions Create full-fledged Excel add-ins Use VBA to work with XML files
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Develop custom Excel VBA macros Perfect for power users, this practical resource reveals how to maximize the features and functionality of Excel 2007. You'll get in-depth details on Excel VBA programming and application development followed by 21 real-world projects--complete with source code--that show you how to set up specific subroutines and functions. The book then explains how to include the subroutines in the Excel menu system and transform a set of interrelated VBA macros into an Excel add-in package. Create your own Excel 2007 VBA macros right away with help from this hands-on guide. Excel 2007 VBA Macro Programming shows you how to: Write and debug VBA code Create custom dialog boxes and buttons Maximize the Excel object model Write code to interact with a database Add functionality to your programs with API calls Insert class modules Develop custom menus for the Ribbon Animate objects in Excel Create and manipulate Pivot Tables in VBA Expand calculation and search functions Create full-fledged Excel add-ins Use VBA to work with XML files

More books from McGraw-Hill Companies,Inc.

Cover of the book Mike Meyers' CompTIA A+ Certification Passport, Fourth Edition (Exams 220-701 & 220-702) by Richard Shepherd
Cover of the book Mike Meyers' CompTIA A+ Guide: Practical Application Lab Manual, Third Edition (Exam 220-702) by Richard Shepherd
Cover of the book Six Sigma Statistics with EXCEL and MINITAB, Chapter 11 - Design of Experiment by Richard Shepherd
Cover of the book Lean Six Sigma, Chapter 1 - Lean Six Sigma: Creating Breakthrough Profit Performance by Richard Shepherd
Cover of the book Perfect Phrases for Office Professionals: Hundreds of ready-to-use phrases for getting respect, recognition, and results in today"s workplace by Richard Shepherd
Cover of the book HVAC Equations, Data, and Rules of Thumb, 2nd Ed. by Richard Shepherd
Cover of the book Lean Six Sigma for Supply Chain Management, Chapter 1 - Using Lean Six Sigma Methods to Identify and Manage Supply Chain Projects by Richard Shepherd
Cover of the book JavaScript Demystified by Richard Shepherd
Cover of the book NetBeans IDE Programmer Certified Expert Exam Guide (Exam 310-045) by Richard Shepherd
Cover of the book Practice Makes Perfect German Conversation by Richard Shepherd
Cover of the book 11 - Supply Chain Management by Richard Shepherd
Cover of the book Six Sigma Business Scorecard, Chapter 13 - Leadership for Performance by Richard Shepherd
Cover of the book Algebra Demystified 2/E by Richard Shepherd
Cover of the book Security Information and Event Management (SIEM) Implementation by Richard Shepherd
Cover of the book Applied Oracle Security: Developing Secure Database and Middleware Environments by Richard Shepherd
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy