|
作者:Richard Shepherd
出版日期:September 3, 2009
出版社:McGraw-Hill
页数:416
ISBN:ISBN-10: 0071627006 ISBN-13: 978-0071627009
文件格式:PDF
Develop custom Excel VBA macros
Perfect for power users, this practical resource reveals how tomaximize the features and functionality of Excel 2007. You’ll getin-depth details on Excel VBA programming and application developmentfollowed by 21 real-world projects–complete with source code–that showyou how to set up specific subroutines and functions. The book thenexplains how to include the subroutines in the Excel menu system andtransform a set of interrelated VBA macros into an Excel add-inpackage. Create your own Excel 2007 VBA macros right away with helpfrom 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
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有账号?注册
×
|