Excel 2007 VBA Macro Programming
List Price:
$55.00
- Availability: Confirm prior to ordering
- Branding: minimum 50 pieces (add’l costs below)
- Check Freight Rates (branded products only)
Branding Options (v), Availability & Lead Times
- 1-Color Imprint: $2.00 ea.
- Promo-Page Insert: $2.50 ea. (full-color printed, single-sided page)
- Belly-Band Wrap: $2.50 ea. (full-color printed)
- Set-Up Charge: $45 per decoration
- Availability: Product availability changes daily, so please confirm your quantity is available prior to placing an order.
- Branded Products: allow 10 business days from proof approval for production. Branding options may be limited or unavailable based on product design or cover artwork.
- Unbranded Products: allow 3-5 business days for shipping. All Unbranded items receive FREE ground shipping in the US. Inquire for international shipping.
- RETURNS/CANCELLATIONS: All orders, branded or unbranded, are NON-CANCELLABLE and NON-RETURNABLE once a purchase order has been received.
Product Details
Author:
Richard Shepherd
Format:
Paperback
Publisher:
McGraw Hill LLC (September 24, 2009)
Audience:
General/trade
ISBN-13:
9780071627009
ISBN-10:
0071627006
Weight:
24oz
Dimensions:
7.4" x 9.2" x 0.87"
Case Pack:
18
File:
McGrawHill-MH_ONIX_V30_US_onix30_all(26_05_19)-20260519.xml
Folder:
McGrawHill
As low as:
$42.35
List Price:
$55.00
Publisher Identifier:
P-MCGRAW
Discount Code:
A
Pages:
416
Pub Discount:
55
Imprint:
McGraw Hill
Overview
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
