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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Jelen, Bill
Otros Autores: Syrstad, Tracy
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Que, 2007.
Colección:Business solutions.
Temas:
Microsoft Excel (Computer file)
Microsoft Visual Basic for applications.
Business > Computer programs.
Electronic spreadsheets.
Tableurs.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares