Libros de Tracy Syrstad
Libros > Libros de informática > Ofimática > VBA & Macros For Micorosoft Office Excel 2007
Portada de Vba & Macros for Micorosoft Office Excel 2007

Vba & Macros for Micorosoft Office Excel 2007

Autor:Tracy Syrstad;
Categoría:Ofimática
ISBN: 9780789736826
QUE nos ofrece Vba & Macros for Micorosoft Office Excel 2007 en inglés, disponible en nuestra tienda desde el 01 de Septiembre del 2007. Amplía tus conocimientos sobre el mundo de los ordenadores con este libro de informática, perfectamente adaptado para todos los lectores por su cuidado contenido. Este libro cuenta con un total de 597 páginas .
Leer argumento »
Ver todas las novedades de libros »

Argumento de Vba & Macros for Micorosoft Office Excel 2007

—Jerry Kohl, president of Brighton Collectibles

Develop your Excel macro programming skills using VBA instantly with proven techniques

Automate Reports

Handle Errors

Master Pivot Tables

Produce Charts

Build User-Defined Functions

Migrate to Excel 2007

Query Web Data

Build Dialog Boxes

Use Data Visualizations

Automate Word

You are an expert in Excel, but the macro recorder doesn’t work and you can’t make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. 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 conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.

  • Learn VBA syntax as easy-to-understand English
  • Automate ExcelÂ’s power tools: Pivot Tables, Charts, Advanced Filters
  • Save hours per week by automating redundant tasks
  • Create applications built on top of Excel with custom dialog boxes
  • Automatically produce hundreds of Excel reports in seconds
  • Understand how changes in Excel 2007 impact your VBA macros

Introduction   1

1 Unleash the Power of Excel with VBA  7

2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar?   29

3 Referring to Ranges 61

4 User-Defined Functions     75

5 Looping and Flow Control   101

6 R1C1-Style Formulas    121

7 What’s New in Excel 2007 and What's Changed  135

8 Create and Manipulate Names in VBA  143

9 Event Programming 155

10 UserForms--An Introduction   177

11 Creating Charts    197

12 Data Mining with Advanced Filter  249

13 Using VBA to Create Pivot Tables     281

14 Excel Power     337

15 Data Visualizations and Conditional Formatting  373

16 Reading from and Writing to the Web  393

17 XML in Excel 2007 413

18 Automating Word  421

19 Arrays   441

20 Text File Processing    449

21 Using Access as a Back End to Enhance Multi-User Access to Data   461

22 Creating Classes, Records, and Collections   477

23 Advanced UserForm Techniques  493

24 Windows Application Programming Interface (API)   517

25 Handling Errors     529

26 Customizing the Ribbon to Run Macros   543

27 Creating Add-Ins  569

Index  577 0

Ultimacomic es una marca registrada por Ultimagame S.L - Ultimacomic.com y Ultimagame.com pertenecen a la empresa Ultimagame S.L - Datos Fiscales: B92641216 - Datos de Inscripción Registral: Inscrita en el Registro Mercantíl de Málaga, TOMO: 3815. LIBRO: 2726. FOLIO: 180. HOJA: MA-77524.
2003 - 2019, COPYRIGHT ULTIMAGAME S.L. - Leer esta página significa estar deacuerdo con la Política de privacidad y de uso