While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book and online, and modify the macro for personal use.
With 101 Ready-to-Use Excel Macros, Microsoft MVP Michael Alexander helps you save time, automate tasks, and ultimately be more productive.
Introduction 1
Part I: Getting Started with Excel Macros 5
Part II: Working with Workbooks 37
Part III: Automating Worksheet Tasks with Macros 71
Part IV: Selecting and Modifying Ranges 103
Part V: Working with Data 137
Part VI: Working with PivotTables 187
Part VII: Manipulating Charts with Macros 233
Part VIII: E-Mailing from Excel 253
Part IX: Integrating Excel and Other Office Applications 273
Index 302
John Walkenbach is author of more than 50 spreadsheet books and lives in southern Arizona.
Visit his website at http://spreadsheetpage.com.
Sa sajta Wileya preuzmite izvorni kod za knjigu. KOD
Svako vaše mišljenje o knjizi, njenoj potrebi za svakodnevni rad i život bi nam bilo od koristi.
© Sva prava pridržana, Kompjuter biblioteka, Beograd, Obalskih radnika 4a, Telefon: +381 11 252 0 272 |
||