Excel 2007 power programming with VBA
This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhereFully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, an...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, N.J. : [Chichester :
Wiley ; John Wiley, distributor
c2007.
|
| Edición: | 1st edition |
| Colección: | Mr. Spreadsheet's bookshelf.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627832806719 |
Tabla de Contenidos:
- Excel 2007 Power Programming with VBA; About the Author; Preface; Topics Covered; What You Need to Know; What You Need to Have; Conventions in This Book; What the Icons Mean; How This Book Is Organized; About the Companion CD-ROM; About the Power Utility Pak Offer; How to Use This Book; Reach Out; Contents at a Glance; Table of Contents; Part I: Some Essential Background; Chapter 1: Excel 2007: Where It Came From; A Brief History of Spreadsheets; Why Excel Is Great for Developers; Excel's Role in Microsoft's Strategy; Chapter 2: Excel in a Nutshell; Thinking in Terms of Objects; Workbooks
- Excel's User InterfaceCustomizing the Display; Data Entry; Formulas, Functions, and Names; Selecting Objects; Formatting; Protection Options; Charts; Shapes and SmartArt; Database Access; Internet Features; Analysis Tools; Add-Ins; Macros and Programming; File Format; Excel's Help System; Chapter 3: Formula Tricks and Techniques; About Formulas; Calculating Formulas; Cell and Range References; Using Names; Formula Errors; Array Formulas; Counting and Summing Techniques; Working with Dates and Times; Creating Megaformulas; Chapter 4: Understanding Excel's Files; Starting Excel; File Types
- Working with Template FilesInside an Excel File; The QAT File; The XLB File; Add-In Files; Excel Settings in the Registry; Part II: Excel Application Development; Chapter 5: What Is a Spreadsheet Application?; Spreadsheet Applications; The Developer and the End User; Solving Problems with Excel; Basic Spreadsheet Types; Chapter 6: Essentials of Spreadsheet Application Development; Determining User Needs; Planning an Application That Meets User Needs; Determining the Most Appropriate User Interface; Concerning Yourself with the End User; Other Development Issues
- Part III: Understanding Visual Basic for ApplicationsChapter 7: Introducing Visual Basic for Applications; Some BASIC Background; About VBA; The Basics of VBA; Introducing the Visual Basic Editor; Working with the Project Explorer; Working with Code Windows; Customizing the VBE Environment; The Macro Recorder; About Objects and Collections; Properties and Methods; The Comment Object: A Case Study; Some Useful Application Properties; Working with Range Objects; Things to Know about Objects; Chapter 8: VBA Programming Fundamentals; VBA Language Elements: An Overview; Comments
- Variables, Data Types, and ConstantsAssignment Statements; Arrays; Object Variables; User-Defined Data Types; Built-in Functions; Manipulating Objects and Collections; Controlling Code Execution; Chapter 9: Working with VBA Sub Procedures; About Procedures; Executing Sub Procedures; Passing Arguments to Procedures; Error-Handling Techniques; A Realistic Example That Uses Sub Procedures; Chapter 10: Creating Function Procedures; Sub Procedures versus Function Procedures; Why Create Custom Functions?; An Introductory Function Example; Function Procedures; Function Arguments; Function Examples
- Emulating Excel's SUM Function
