Primer in Excel VBA -- The application object -- Workbooks and worksheets -- Using ranges -- Using names -- Data lists -- PivotTables -- Charts -- Event procedures -- Adding controls -- Text files and file dialog -- Working with XML and the open XML file formats -- UserForms -- RibbonX -- Command bars -- Class modules -- Add-ins -- Automation add-ins and COM add-ins -- Interacting with other office applications -- Data access with ADO -- Managing external data -- The trust center and document security -- Browsing OLAP data sources with Excel -- Excel and the Internet -- International issues -- Programming the VBE -- Programming with the Windows API -- Appendix A: Excel 2007 object model -- Appendix B: VBE object model -- Appendix C: Office 2007 object model.
0
Fully updated and expanded to cover Microsoft Office Excel 2007, this book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications.; Begins with an overview of VBA, the programming language for the Microsoft Office suite and many other applications, which allows users to do anything from automating Excel tasks to developing full applications with Excel as the development environment.