VBA and Macros for Microsoft Office Excel 2007

Note moyenne 3,95
( 20 avis fournis par GoodReads )
 
9780789736826: VBA and Macros for Microsoft Office Excel 2007
Présentation de l'éditeur :

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

 

Biographie de l'auteur :

Bill Jelen, Excel MVP and MrExcel, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill has made more than 50 guest appearances on Call for Help with Leo Laporte and has produced more than 250 episodes of his daily video podcast, Learn Excel from MrExcel. He is the host of Total Training’s Excel 2007 Advanced DVD. He also enjoys taking his show on the road, doing a one- to four-hour power Excel seminar anywhere that a room full of accountants or Excellers will show up. Before founding MrExcel.com, Jelen spent 12 years in the trenches–working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary Ellen, and sons, Josh and Zeke.

 

Tracy Syrstad remembers the painful trek up the VBA learning curve while developing applications for herself and co-workers at a former job. Now, as the project manager for the MrExcel consulting team, she enjoys helping clients develop custom solutions for their unique situations, observing the myriad ways people use Excel and other Microsoft Office applications.

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

Meilleurs résultats de recherche sur AbeBooks

1.

Bill Jelen, Tracy Syrstad
Edité par Que Publishing (2007)
ISBN 10 : 0789736829 ISBN 13 : 9780789736826
Neuf(s) Paperback Quantité : 1
Vendeur
Ergodebooks
(RICHMOND, TX, Etats-Unis)
Evaluation vendeur
[?]

Description du livre Que Publishing, 2007. Paperback. État : New. 1. N° de réf. du libraire DADAX0789736829

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 21,90
Autre devise

Ajouter au panier

Frais de port : EUR 12,83
De Etats-Unis vers France
Destinations, frais et délais

2.

Jelen, Bill; Syrstad, Tracy
Edité par Que Publishing (2007)
ISBN 10 : 0789736829 ISBN 13 : 9780789736826
Neuf(s) Paperback Quantité : 1
Vendeur
Irish Booksellers
(Rumford, ME, Etats-Unis)
Evaluation vendeur
[?]

Description du livre Que Publishing, 2007. Paperback. État : New. book. N° de réf. du libraire 0789736829

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 35,19
Autre devise

Ajouter au panier

Frais de port : EUR 11
De Etats-Unis vers France
Destinations, frais et délais

3.

Bill Jelen, Tracy Syrstad
Edité par Pearson Education (US), United States (2007)
ISBN 10 : 0789736829 ISBN 13 : 9780789736826
Neuf(s) Paperback Quantité : 10
Vendeur
The Book Depository
(London, Royaume-Uni)
Evaluation vendeur
[?]

Description du livre Pearson Education (US), United States, 2007. Paperback. État : New. 1st Revised edition. 241 x 178 mm. Language: English . Brand New Book. 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 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. N° de réf. du libraire PEA9780789736826

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 45,98
Autre devise

Ajouter au panier

Frais de port : EUR 1,41
De Royaume-Uni vers France
Destinations, frais et délais

4.

Bill Jelen, Tracy Syrstad
Edité par Pearson Education (US), United States (2007)
ISBN 10 : 0789736829 ISBN 13 : 9780789736826
Neuf(s) Paperback Quantité : 10
Vendeur
The Book Depository US
(London, Royaume-Uni)
Evaluation vendeur
[?]

Description du livre Pearson Education (US), United States, 2007. Paperback. État : New. 1st Revised edition. 241 x 178 mm. Language: English . Brand New Book. 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 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. N° de réf. du libraire PEA9780789736826

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 46,12
Autre devise

Ajouter au panier

Frais de port : EUR 1,41
De Royaume-Uni vers France
Destinations, frais et délais

5.

Jelen, Bill/ Syrstad, Tracy
Edité par Que Pub (2007)
ISBN 10 : 0789736829 ISBN 13 : 9780789736826
Neuf(s) Paperback Quantité : 1
Vendeur
Revaluation Books
(Exeter, Royaume-Uni)
Evaluation vendeur
[?]

Description du livre Que Pub, 2007. Paperback. État : Brand New. 2nd edition. 598 pages. 9.00x7.00x1.00 inches. In Stock. N° de réf. du libraire 0789736829

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 41,30
Autre devise

Ajouter au panier

Frais de port : EUR 7,07
De Royaume-Uni vers France
Destinations, frais et délais

6.

Jelen, Bill; Syrstad, Tracy
Edité par QUE (2007)
ISBN 10 : 0789736829 ISBN 13 : 9780789736826
Neuf(s) soft Quantité : > 20
Vendeur
Agapea Libros Urgentes
(Malaga, Espagne)
Evaluation vendeur
[?]

Description du livre QUE, 2007. soft. État : New. Â"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 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. N° de réf. du libraire 1204037

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 40,71
Autre devise

Ajouter au panier

Frais de port : EUR 10
De Espagne vers France
Destinations, frais et délais

7.

Jelen, Bill; Syrstad, Tracy
Edité par Que Publishing (2007)
ISBN 10 : 0789736829 ISBN 13 : 9780789736826
Neuf(s) Couverture souple Quantité : > 20
Vendeur
Palexbooks
(Sanford, NC, Etats-Unis)
Evaluation vendeur
[?]

Description du livre Que Publishing, 2007. État : New. Brand new! Please provide a physical shipping address. N° de réf. du libraire 9780789736826

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 45,94
Autre devise

Ajouter au panier

Frais de port : EUR 36,67
De Etats-Unis vers France
Destinations, frais et délais

8.

Jelen, Bill; Syrstad, Tracy
Edité par Que Publishing
ISBN 10 : 0789736829 ISBN 13 : 9780789736826
Neuf(s) PAPERBACK Quantité : 1
Vendeur
Cloud 9 Books
(West Palm Beach, FL, Etats-Unis)
Evaluation vendeur
[?]

Description du livre Que Publishing. PAPERBACK. État : New. 0789736829 New Condition. N° de réf. du libraire NEW6.0437182

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 47,20
Autre devise

Ajouter au panier

Frais de port : EUR 36,66
De Etats-Unis vers France
Destinations, frais et délais

9.

Bill Jelen
ISBN 10 : 0789736829 ISBN 13 : 9780789736826
Neuf(s) Quantité : 1
Vendeur
Castle Rock
(Pittsford, NY, Etats-Unis)
Evaluation vendeur
[?]

Description du livre État : Brand New. Book Condition: Brand New. N° de réf. du libraire 97807897368261.0

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 61,24
Autre devise

Ajouter au panier

Frais de port : EUR 22,92
De Etats-Unis vers France
Destinations, frais et délais