| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910144136703321 |
|
|
Autore |
Walkenbach John |
|
|
Titolo |
Excel 2007 power programming with VBA [[electronic resource] /] / by John Walkenbach |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Hoboken, N.J., : Wiley |
|
[Chichester, : John Wiley, distributor], c2007 |
|
|
|
|
|
|
|
|
|
ISBN |
|
1-281-73243-5 |
9786611732431 |
1-118-25759-6 |
0-470-15130-7 |
|
|
|
|
|
|
|
|
Edizione |
[1st edition] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (1106 p.) |
|
|
|
|
|
|
Collana |
|
Mr. Spreadsheet's bookshelf |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Visual programming (Computer science) |
Electronic books. |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di contenuto |
|
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 |
|
|
|
|
|
|
Sommario/riassunto |
|
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, and techniques readers won't find anywhere elseJohn Walkenbach, aka ""Mr. Spreadsheet,"" is one of the world's leading authorities on ExcelThoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded coll |
|
|
|
|
|
|
|
| |