VBA and macros for Microsoft Office Excel 2007
“In this day and age of ‘too much information and not enough time,’ the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of.” —Jerry Kohl, president of Brig...
| Otros Autores: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified]
Que
2008
|
| Edición: | 1st edition |
| Colección: | Business solutions
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627118706719 |
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.
