VBA and macros for Microsoft Office Excel 2007 /

"This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conce...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Jelen, Bill
Other Authors: Syrstad, Tracy
Format: Electronic eBook
Language:Inglés
Published: Indianapolis, Ind. : Que, 2007.
Series:Business solutions.
Subjects:
Microsoft Excel (Computer file)
Microsoft Visual Basic for applications.
Business > Computer programs.
Electronic spreadsheets.
Tableurs.
Online Access:Texto completo (Requiere registro previo con correo institucional)
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.

Similar Items