Excel 2007 VBA Programmers Reference

Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.

(Computer Bookshops Limited)

Bli först med att recensera och betygsätt boken Excel 2007 VBA Programmers Reference - du kan vinna 200 kr varje månad i tävlingen "Månadens recension".

Rob Bovey is a software developer specializing in Microsoft Office, Visual Basic, and SQL Server applications. He is founder and president of the custom application development firm Application Professionals. Rob developed several Addins shipped by Microsoft for Excel. He also co authored the Microsoft Excel 97 Developer s Kit. Stephen Bullen, Carlow, Ireland, started his own company in 1997, Business Modeling Solutions Ltd, specializing in Excel and Access development and consulting. He has developed many tools and utilities to extend Excel s functionality. Stephen enjoys helping other Excel users and devotes a lot of his spare time to answering questions in forums and newsgroups. In recognition of his contributions and knowledge, Microsoft has awarded him the status of MVP every year since 1996. John Green, Sydney Australia, is an independent consultant specializing in Excel and Access. With 30 years of computing experience, a Chemical Engineering degree and an MBA, he draws from a diverse background. He has led training courses for software applications and operating systems both in Australia and overseas. Robert Rosenberg runs his own consulting business, which specializes in Microsoft Office, advanced training and custom solutions for numerous entertainment, financial, and legal organizations. As a Microsoft Valuable Professional in Excel, he also continually offers advanced online support ion Excel on behalf of Microsoft to users of their Internet newsgroups.

(Computer Bookshops Limited)

Acknowledgements.

Introduction.

Chapter 1: Primer in Excel VBA.

Chapter 2: The Application Object.

Chapter 3: Workbooks and Worksheets.

Chapter 4: Using Ranges.

Chapter 5: Using Names.

Chapter 6: Filtered Lists.

Chapter 7: PivotTables.

Chapter 8:Charts.

Chapter 9: Event Procedures.

Chapter 10: Adding Controls.

Chapter 11: Text Files and File Dialog.

Chapter 12: Working with XML and the Open XML File Formats.

Chapter 13: UserForms.

Chapter 14: RibbonX.

Chapter 15: Command Bars.

Chapter 16: Class Modules.

Chapter 17: Add-ins.

Chapter 18: Automation Add-ins and COM Add-ins.

Chapter 19: Interacting with Other Office Applications.

Chapter 20: Data Access with ADO.

Chapter 21: Managing External Data.

Chapter 22: The Trust Center and Document Security.

Chapter 23: Browsing OLAP Data Sources with Excel.

Chapter 24: Excel and the Internet.

Chapter 25: International Issues.

Chapter 26: Programming the VBE.

Chapter 27: Programming with the Windows API.

Appendix A: Excel 2002 Object Model

Appendix B: VBE Object Model.

Appendix C: Office 2007 Object Model.

Index.

(Computer Bookshops Limited)