Excel VBA Macro Programming

Excel VBA Macro Programming by Richard Shepherd, Richard Shepherd
320 pages; Publisher: McGraw-Hill Osborne Media; 1 edition (January 5, 2004); ISBN: 0072231440

Develop powerful, custom Excel applications using Visual Basic for Applications Maximize the features and functionality of Excel with help from this unique resource designed specifically for power users. Inside, you’ll find complete details on Excel VBA programming and application development from the fundamentals to advanced techniques. Then, you’ll get 21 real-world projects, complete with working code, so you can create Excel VBA macros right away. These projects include everything from setting up timed events to auto totaling a matrix of numbers to altering the appearance of spreadsheet components and much more.
  • Write and debug VBA code
  • Create custom dialog boxes and toolbars
  • Take advantage of the Excel object model
  • Write code to interact with a database
  • Use application programming interface (API) calls
  • Create and use class modules
  • Develop unique menus within the Excel menu structure
  • Expand calculation and search functions
  • Write macros for customized worksheets
  • Create full-fledged Excel add-ins

Make Excel work harder and faster for you. This unique book presents sample code for more than twenty practical, high-powered Excel VBA macro applications. You’ll get all the essentials of VBA, and then explore ways to power Excel with VBA. Automate tasks, convert numbers to labels, transpose cells, add formula details, globally changes values, and much, much more.

Excel VBA Macro Programming 6,03 мб



Опубликовал admin
9 Дек, Четверг 2004г.



Программирование для чайников.