SaraDaddy

Main » 2018 » April » 20 » Excel 2010 Power Programming with VBA + Examples

---

15:31:56 Excel 2010 Power Programming with VBA + Examples

Excel 2010  Power Programming with VBA + Examples Size : 11.94 Mb Author : John Walkenbach Format : PDF Pages : 1052 If your job involves developing Excel workbooks that others will use or if you simply want to get the most out of Excel tjis book is for you. This book focuses on Visual Basic for Applications (VBA), the programming language built into Excel (and other applications that make up Microsoft Office). More specifically, it will show you how to write programs that automate various tasks in Excel. This book covers everything from recording simple macros through creating sophisticated user-oriented applications and utilities. This book does not cover Microsoft Visual Studio Tools for Office (VSTO). VSTO is a relatively new technology that uses Visual Basic .NET and Microsoft Visual C#. VSTO can also be used to control Excel and other Microsoft Office applications. This is not a book for beginning Excel users. If you have no experience with Excel, a better choice might be my Excel 2010 Bible, which provides comprehensive coverage of all the features of Excel. That book is meant for users of all levels. To get the most out of this book, you should be a relatively experienced Excel user. In this book is assumed that you know the following : How to create workbooks, insert sheets, save files, and so on How to navigate through a workbook How to use the Excel Ribbon user interface How to enter formulas How to use Excel’s worksheet functions How to name cells and ranges How to use basic Windows features, such as file management techniques and the Clipboard How This Book Is Organized The chapters of this book are grouped into eight main parts : Part I: Some Essential Background In this part, is sets the stage for the rest of the book. Chapter 1 presents a brief history of spreadsheets so that you can see how Excel fits into the big picture. In Chapter 2, offer a conceptual overview of Excel 2010 quite useful for experienced spreadsheet users who are switching to Excel. In Chapter 3, is covered the essentials of formulas, including some clever techniques that might be new to you. Chapter 4 covers the ins and outs of the various files used and generated by Excel. Part II: Excel Application Development This part consists of just two chapters. In Chapter 5, is broadly discuss the concept of a spreadsheet application. Chapter 6 goes into more detail and covers the steps typically involved in a spreadsheet application development project. Part III: Understanding Visual Basic for Applications Chapters 7 through 11 make up Part III, and these chapters include everything that you need to know to learn VBA. In this part, you'll be introduced with VBA, provide programming fundamentals, and detail how to develop VBA subroutines and functions. Chapter 11 contains many useful VBA examples. Part IV: Working with UserForms The four chapters in this part cover custom dialog boxes (also known as UserForms). Chapter 12 presents some built-in alternatives to creating custom UserForms. Chapter 13 provides an introduction to UserForms and the various controls that you can use. Chapters 14 and 15 present many examples of custom dialog boxes, ranging from basic to advanced. Part V: Advanced Programming Techniques Part V covers additional techniques that are often considered advanced. The first three chapters discuss how to develop utilities and how to use VBA to work with pivot tables and charts (including the new Sparkline graphics). Chapter 19 covers event handling, which enables you to execute procedures automatically when certain events occur. Chapter 20 discusses various techniques that you can use to interact with other applications (such as Word). Chapter 21 concludes Part V with an in-depth discussion of creating add-ins. Part VI: Developing Applications The chapters in Part VI deal with important elements of creating user-oriented applications. Chapter 22 discusses how to modify the new Ribbon interface. Chapter 23 describes how to modify Excel’s shortcut menus. Chapter 24 presents several different ways to provide online help for your applications. In Chapter 25, I present some basic information about developing useroriented applications, and here is described such an application in detail. Part VII: Other Topics The six chapters in Part VII cover additional topics. Chapter 26 presents information regarding compatibility. In Chapter 27, discuss various ways to use VBA to work with files. In Chapter 28, is explained how to use VBA to manipulate Visual Basic components such as UserForms and modules. Chapter 29 covers the topic of class modules. Chapter 30 explains how to work with color in Excel. The part VII finished with a useful chapter that answers many common questions about Excel programming. Part VIII: Appendixes Four appendixes round out the book. Appendix A contains useful information about Excel resources online. Appendix B is a reference guide to all VBA’s keywords (statements and functions). In appendix C explained VBA error codes, and Appendix D describes the files available on the companion CD-ROM. Check links with this FILEFACTORY LINK CHECKER If links are dead, please leave comment in the post. http://www.filefactory.com/file/44s2j9f5zxe3/

1 2 3 4 5 Category: e-BOOKS | Views: 459 | Added by: saradaddy | Rating: 5.0/1

Total comments: 0