EXCEL 2007 VBA MACRO PROGRAMMING
商品資訊
ISBN13:9780071627009
出版社:Mcgraw-Hill; Inc.
作者:RICHARD SHEPHERD
出版日:2009/09/03
裝訂/頁數:平裝/386頁
規格:24.1cm*19.1cm*2.5cm (高/寬/厚)
商品簡介
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
作者簡介
Richard Shepherd is a qualified accountant who has spent the last 20 years developing computer software in blue-chip organizations. He is the author of the previous edition of this book.
目次
Part I. Programming in Excel VBA
Ch. 1. The Basics
Ch. 2. Variables, Arrays, Constants, and Data Types
Ch. 3. Modules, Functions, and Subroutines
Ch. 4. Programming Basics: Decisions and Looping
Ch. 5. Strings and Functions and Message Boxes
Ch. 6. Operators
Ch. 7. Debugging
Ch. 8. Errors and the Error Function
Ch. 9. Dialogs
Ch. 10. Common Dialog Control
Ch. 11. Command Bars and Buttons
Part II. Object Models
Ch. 12. The Excel Object Model
Ch. 13. The Excel Object Model--Main Objects
Ch. 14. Using Excel to Interact with Other Office Programs
Ch. Part III. Advanced Techniques in Excel VBA
Ch. 15. Charts and Graphs
Ch. 16. Working with Databases
Ch. 17. API Calls
Ch. 18. Class Modules
Ch. 19. Animation
Ch. 20. Working with XML Files
Ch. 21. The Ribbon
Ch. 22. Pivot Tables
Part IV. VBA in Action
Ch. 23. Converting Labels to Numbers and Numbers to Labels
Ch. 24. Transposing a Range of Cells
Ch. 25. Adding Formula Details into Comments
Ch. 26. Calculating a Range
Ch. 27. Reversing a Label
Ch. 28. Who Created the Workbook
Ch. 29. Evaluating a Cell
Ch. 30. Sorting Worksheets into Alphabetical Order
Ch. 31. Replacing Characters in a String
Ch. 32. Timed Events
Ch. 33. Auto-Totaling a Matrix of Numbers
Ch. 34. Absolute and Relative Formulas
Ch. 35. Coloring Alternate Rows and Columns of the Spreadsheet
Ch. 36. Coloring Cells Containing Formulas
Ch. 37. Summing Cells by Reference to a Master Cell
Ch. 38. Globally Changing a Range of Values
Ch. 39. Displaying Hidden Sheets Without a Password
Ch. 40. Searching Multiple Sheets and Workbooks
Ch. 41. Brighten Up Your Comments
Ch. 42. Importing a CSV File Containing Leading Zeros
Ch. 43. Working with Shapes
Ch. 44. Turning Your VBA Code into a Add-In
Appendix. ASCII Character Codes
Index
主題書展
更多書展今日66折
您曾經瀏覽過的商品
購物須知
外文書商品之書封,為出版社提供之樣本。實際出貨商品,以出版社所提供之現有版本為主。部份書籍,因出版社供應狀況特殊,匯率將依實際狀況做調整。
無庫存之商品,在您完成訂單程序之後,將以空運的方式為你下單調貨。為了縮短等待的時間,建議您將外文書與其他商品分開下單,以獲得最快的取貨速度,平均調貨時間為1~2個月。
為了保護您的權益,「三民網路書店」提供會員七日商品鑑賞期(收到商品為起始日)。
若要辦理退貨,請在商品鑑賞期內寄回,且商品必須是全新狀態與完整包裝(商品、附件、發票、隨貨贈品等)否則恕不接受退貨。