VBA and macros for Microsoft Office Excel 2007

• Main Authors: Jelen, Bill, 1965- (Author), Syrstad, Tracy (Author)
• Format: Book
• Language: English
• Published: Indianapolis, Ind. : Que, c2008
• Edition: [2nd ed.]
• Series: Business solutions
• Subjects: Microsoft Excel 2007 (software); tabulkové procesory; makroinstrukce; Microsoft Visual Basic for Applications (programovací jazyk); Microsoft Excel 2007; electronic spreadsheets; macro instructions; Microsoft Visual Basic for Applications; příručky; handbooks, manuals, etc
• ISBN: 9780789736826 0-7897-3682-9
• Physical Description: xxiii, 598 s. : il. ; 24 cm

Table of Contents:

• Unleash the power of Excel with VBA
• This sounds like BASIC, so why doesn't it look familiar?
• Referring to ranges
• User-defined functions
• Looping and flow control
• R1C1-style formulas
• What's new in Excel 2007 and what's changed
• Create and manipulate names in VBA
• Event programming
• Userforms--an introduction
• Creating charts
• Data mining with advanced filter
• Excel power
• Data visualizations and conditional formatting
• Reading from and writing to the Web
• XML in Excel 2007
• Automating Word
• Arrays
• Text file processing
• Using Access as a back end to enhance multi-user access to data
• Creating classes, records, and collections
• Advanced userform techniques
• Windows application programming interface (API)
• Handling errors
• Customizing the ribbon to run macros
• Creating add-ins