Excel 2007 VBA Macro Programming, 2/e (Paperback)

Richard Shepherd

  • 出版商: McGraw-Hill Education
  • 出版日期: 2009-09-24
  • 售價: $1,960
  • 貴賓價: 9.5$1,862
  • 語言: 英文
  • 頁數: 416
  • 裝訂: Paperback
  • ISBN: 0071627006
  • ISBN-13: 9780071627009
  • 相關分類: Excel
  • 已過版

買這商品的人也買了...

相關主題

商品描述

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