8/10/2019 Livro 042111.txt

1/21

Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to c

reate simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.

Chapter 9 shows how to use compoChapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Ex

cel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so your

8/10/2019 Livro 042111.txt

2/21

client spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use compoChapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual Studio

Tools for Office 2005.or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so your

client spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPoint

presentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use compoChapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologies

8/10/2019 Livro 042111.txt

3/21

in Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Offi

ce applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use compoChapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologies

in Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel projec

t so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.

8/10/2019 Livro 042111.txt

4/21

Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use compoyour Excel 2007 projects. Examples from earlierchapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collec

tion tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 in

your Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 ayour Excel 2007projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is the

required solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excel

8/10/2019 Livro 042111.txt

5/21

charting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 a

or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is the

required solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how t

o effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.or pretty charts? If you want to learn how to bring data i

nto your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 has

8/10/2019 Livro 042111.txt

6/21

expanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Ex

cel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collec

tion tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 in

nd Visual StudioTools for Office 2005.or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when i

8/10/2019 Livro 042111.txt

7/21

t is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using Ac

tiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 has

expanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.

Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.Chapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,

8/10/2019 Livro 042111.txt

8/21

and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.Chapter 4 looks at Excel 2007 UserForms and the tools they provide. Its examplesshowhow to build simple and complex data entry forms, and how to use classes to addfunctionalityto the UserForms.Chapter 5 explores charting in Excel 2007. After examining the code created by the MacroRecorder, it shows how to use the Chart object in code.Chapter 6 takes a look at Excel PivotTable reports. PivotTables are powerful data analysis

tools, and theyre easy to create and modify. The code samples show how to createand modifyPivotTable reports.Chapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.

Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.in Excel that you get in the full-fledged programming languages: ease of reuse, easiercode maintenance, encapsulation, and more.You will find sample files and code solutions in the Source Code/Download section of theDid you ever wonder whether there is more to Excel than data displayed in rows and columnsor pretty charts? If you want to learn how to bring data into your Excel 2007 projects, or

learn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel projec

8/10/2019 Livro 042111.txt

9/21

t so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.Chapter 4 looks at Excel 2007 UserForms and the tools they provide. Its examplesshowhow to build simple and complex data entry forms, and how to use classes to add

functionalityto the UserForms.Chapter 5 explores charting in Excel 2007. After examining the code created by the MacroRecorder, it shows how to use the Chart object in code.Chapter 6 takes a look at Excel PivotTable reports. PivotTables are powerful data analysistools, and theyre easy to create and modify. The code samples show how to createand modifyPivotTable reports.Chapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how t

o effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.in Excel that you get in the full-fledged programming lang

uages: ease of reuse, easiercode maintenance, encapsulation, and more.You will find sample files and code solutions in the Source Code/Download section of theDid you ever wonder whether there is more to Excel than data displayed in rows and columnsor pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.

8/10/2019 Livro 042111.txt

10/21

I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 in

your Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.Chapter 4 looks at Excel 2007 UserForms and the tools they provide. Its examplesshowhow to build simple and complex data entry forms, and how to use classes to addfunctionalityto the UserForms.Chapter 5 explores charting in Excel 2007. After examining the code created by the MacroRecorder, it shows how to use the Chart object in code.Chapter 6 takes a look at Excel PivotTable reports. PivotTables are powerful dat

a analysistools, and theyre easy to create and modify. The code samples show how to createand modifyPivotTable reports.Chapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPoint

presentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.in Excel that you get in the full-fledged programming languages: ease of reuse, easiercode maintenance, encapsulation, and more.You will find sample files and code solutions in the Source Code/Download sectio

8/10/2019 Livro 042111.txt

11/21

n of theDid you ever wonder whether there is more to Excel than data displayed in rows and columnsor pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTablChapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.

Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.Chapter 4 looks at Excel 2007 UserForms and the tools they provide. Its examplesshow

how to build simple and complex data entry forms, and how to use classes to addfunctionalityto the UserForms.Chapter 5 explores charting in Excel 2007. After examining the code created by the MacroRecorder, it shows how to use the Chart object in code.Chapter 6 takes a look at Excel PivotTable reports. PivotTables are powerful data analysistools, and theyre easy to create and modify. The code samples show how to createand modifyPivotTable reports.Chapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,

and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 in

8/10/2019 Livro 042111.txt

12/21

8/10/2019 Livro 042111.txt

13/21

Excel 2007,in Excel that you get in the full-fledged programming languages: ease of reuse, easiercode maintenance, encapsulation, and more.You will find sample files and code solutions in the Source Code/Download section of theDid you ever wonder whether there is more to Excel than data displayed in rows and columnsor pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and in

Excel 2007,PivotTables are greatly enhanced.of this book, it has many, many possibilities,and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,in Excel that you get in the full-fledged programming languages: ease of reuse, easiercode maintenance, encapsulation, and more.

You will find sample files and code solutions in the Source Code/Download section of theDid you ever wonder whether there is more to Excel than data displayed in rows and columnsor pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to lear

n. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,PivotTables are greatly enhanced.of this book, it has many, many possibilities,

8/10/2019 Livro 042111.txt

14/21

and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,in Excel that you get in the full-fledged programming languages: ease of reuse, easiercode maintenance, encapsulation, and more.You will find sample files and code solutions in the Source Code/Download section of theDid you ever wonder whether there is more to Excel than data displayed in rows and columnsor pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to lear

n. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,PivotTables are greatly enhanced.of this book, it has many, many possibilities,and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so your

client spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,in Excel that you get in the full-fledged programming languages: ease of reuse, easiercode maintenance, encapsulation, and more.You will find sample files and code solutions in the Source Code/Download section of theDid you ever wonder whether there is more to Excel than data displayed in rows and columnsor pretty charts? If you want to learn how to bring data into your Excel 2007 projects, or

learn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel projec

8/10/2019 Livro 042111.txt

15/21

t so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,PivotTables are greatly enhanced.of this book, it has many, many possibilities,and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,Chapter 4 looks at Excel 2007 UserForms and the tools they provide.Its examples showhow to build simple and complex data entry forms, and how to use classes to addfunctionalityto the UserForms.Chapter 5 explores charting in Excel 2007. After examining the code created by the MacroRecorder, it shows how to use the Chart object in code.

Chapter 6 takes a look at Excel PivotTable reports. PivotTables are powerful data analysistools, and theyre easy to create and modify. The code samples show how to createand modifyPivotTable reports.Chapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPo

intpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.Chapter 4 looks at Excel 2007 UserForms and the tools they provide. Its examplesshowhow to build simple and complex data entry forms, and how to use classes to addfunctionalityto the UserForms.

Chapter 5 explores charting in Excel 2007. After examining the code created by the MacroRecorder, it shows how to use the Chart object in code.Chapter 6 takes a look at Excel PivotTable reports. PivotTables are powerful data analysistools, and theyre easy to create and modify. The code samples show how to createand modifyPivotTable reports.Chapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,

8/10/2019 Livro 042111.txt

16/21

and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.in Excel that you get in the full-fledged programming languages: ease of reuse, easiercode maintenance, encapsulation, and more.You will find sample files and code solutions in the Source Code/Download section of theDid you ever wonder whether there is more to Excel than data displayed in rows and columnsor pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.

I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and in

Excel 2007,PivotTables are greatly enhanced.in Excel that you get in the full-fledged programming languages: ease of reuse,easiercode maintenance, encapsulation, and more.You will find sample files and code solutions in the Source Code/Download section of theDid you ever wonder whether there is more to Excel than data displayed in rows and columnsor pretty charts? If you want to learn how to bring data into your Excel 2007 projects, orlearn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.

I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simple

8/10/2019 Livro 042111.txt

17/21

user interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,PivotTables are greatly enhanced.of this book, it has many, many possibilities,and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,PivotTables are greatly enhanced.This book also addresses object-oriented programming to a great degree. Just becauseyoure not writing a .NET or even a classic Visual Basic application, theres no reason you cantuse object-oriented coding techniques in your projects. It provides you with thesame advantagesin Excel that you get in the full-fledged programming languages: ease of reuse,easiercode maintenance, encapsulation, and more.

You will find sample files and code solutions in the Source Code/Download section of theof this book, it has many, many possibilities, and it is relatively easyto learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel project so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,PivotTables are greatly enhanced.This book also addresses object-oriented programming to a great degree. Just bec

auseyoure not writing a .NET or even a classic Visual Basic application, theres no reason you cantuse object-oriented coding techniques in your projects. It provides you with thesame advantagesin Excel that you get in the full-fledged programming languages: ease of reuse,easiercode maintenance, encapsulation, and more.You will find sample files and code solutions in the Source Code/Download section of theDid you ever wonder whether there is more to Excel than data displayed in rows and columnsor pretty charts? If you want to learn how to bring data into your Excel 2007 projects, or

learn to work with XML, or see how object-oriented programming can be used in Excel 2007,this book will provide you with that information.I wrote this book because Ive always enjoyed writing applications in Excel when it is therequired solution. Excel is often overlooked in coding situations, but as youll see in the pagesof this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 hasexpanded XML support. XML data is easily brought into and out of an Excel projec

8/10/2019 Livro 042111.txt

18/21

t so yourclient spreadsheet data can be shared. Excel UserForms give you the ability to create simpleuser interfaces for your clients and allow you to create easy-to-use data collection tools. Excelcharting and PivotTables have always been a strong suit for data summary, and inExcel 2007,PivotTables are greatly enhanced.This book also addresses object-oriented programming to a great degree. Just becauseyoure not writing a .NET or even a classic Visual Basic application, theres no reason you cantuse object-oriented coding techniques in your projects. It provides you with thesame advantagesin Excel that you get in the full-fledged programming languages: ease of reuse,easiercode maintenance, encapsulation, and more.You will find sample files and code solutions in the Source Code/Download section of theApress web site, at www.apress.com.Who This Book Is ForThis book is intended for developers who would like to learn to use Visual Basicfor Applications(VBA) to extend the power of Microsoft Excel 2007. You should have some knowledg

e ofor experience using the VBA or classic Visual Basic programming languages and their relateddevelopment environment.Anyone with VBA, Visual Basic, Microsoft Access, or .NET experience will readilyunderstandthe concepts in this book, but anyone with any coding experience should have noproblem with the material.How This Book Is StructuredThis book gives a view into the many features available to todays Excel developer, from atour of the Visual Basic Editor, where coding is done, to its debugging features. It also provides

modern coding techniques, including object-oriented programming. Youll learnabout data access, XML, charting, and PivotTables, UserForms, and more.Chapter 1 is a basic tour of Excel 2007 coding features, from the development environmentto other tools youll use. It begins with an examination of the Visual Basic Editor andxviishows some of its features. It then looks at the Excel Macro Recorder and the code it generatesfor you, talks about the different types of code modules available to you, and discusses thetypes of code you can write.Chapter 2 details methods of bringing data into and out of Excel projects. It co

versimporting from Microsoft Access data, text files, and SQL Server data. It also discusses themany data access options available, including DAO, ADO, and ODBC.Chapter 3 discusses using the XML features in Excel 2007. Examples include importingand exporting data to an XML file and appending data from an XML file. It showshow to builda custom object in a class module to work with XML files. It also shows how to build a custom

8/10/2019 Livro 042111.txt

19/21

user interface component using XML.Chapter 4 looks at Excel 2007 UserForms and the tools they provide. Its examplesshowhow to build simple and complex data entry forms, and how to use classes to addfunctionalityto the UserForms.Chapter 5 explores charting in Excel 2007. After examining the code created by the MacroRecorder, it shows how to use the Chart object in code.Chapter 6 takes a look at Excel PivotTable reports. PivotTables are powerful data analysistools, and theyre easy to create and modify. The code samples show how to createand modifyPivotTable reports.Chapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,and Watch windows are shown in detail. The section on error handling shows how to effectivelytrap for errors and how to provide positive feedback to the user.Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.Its examples include building a chart report in Word 2007 and building a PowerPointpresentation that includes text and charts from an Excel workbook.

Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio2005 inyour Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologiesin Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual StudioTools for Office 2005.PrerequisitesMicrosoft Excel 2007 is required for the examples in this book. For Chapter 8, Office Integration,youll need Microsoft Word 2007 and PowerPoint 2007.SQL Server 2005 Management Studio Express is used in our SQL data examples. Thisis available for download from the Apress web site (www.apress.com), in the Source Code/

Download section.To create the code for Chapter 9, ActiveX and .NET,youll need Visual Basic 5 or 6(forthe ActiveX section) and Visual Studio 2005 and Visual Studio Tools for Office 2005 SE (for the.NET section). If you do not have one or both of the above, the compiled components for eachexample are provided on the Apress web site. The .NET Framework 2.0 should be installed onyour PC for the .NET examples to run. If you do not have Visual Studio 2005, youll be able torun the samples, but you wont have direct access to the code.xviii nINTRODUCTION

Downloading the CodeThe source code for this book is available to readers at www.apress.com, in theSource Code/Download section. Please feel free to visit the Apress web site and download allthe code there.You can also check for errata and find related titles from Apress.Contacting the AuthorContact Jim DeMarco at jim.demarco@hcheq.org. For more information on HCHEQ andits mission, go to www.hcheq.org. For information on Jims musical endeavors, go to www.

8/10/2019 Livro 042111.txt

20/21

fiftyhabit.com or contact him at info@fiftyhabit.com.nINTRODUCTION xix

The Macro Recorder andCode ModulesThis book is written for experienced coders. You may have experience in many languages,but not in the Excel (or Office) VBA IDE. We will be writing quite a bit of codeas we movealong, but before we do that, lets take a quick look at Excels Macro Recorder andthe VisualBasic Development Environment. The Macro Recorder has been a part of Excel for quite along time, and its still the best way to get a look at some of the objects that make up the ExcelDocument Object Model (DOM), and a great way to get the core of your code written for youas you start your development projects.Macro Security SettingsExcels default security settings do not allow any macro activity. Before you begin exploringmacros in Excel and the Macro Recorder, you will need to tell Excel which security settings touse to control what happens when you open a workbook that contains macros (or on

e thatwill contain macros). If you use antivirus software that works with Microsoft Office 2007 andyou open a workbook that contains macros, the virus scanner will check the workbook forviruses before opening it.You can make changes to the macro security settings in the Trust Center:1. Click the Microsoft Office button, which looks like the following:2. Click the Excel Options button, select Trust Center, click the Trust Center Settingsbutton, and finally click the Macro Settings item.Alternatively, on the Developer ribbon, click the Macro Security button in the Code Group

section. (Depending on the network security level at your organization, you mayor may nothave rights to change these settings).nNote Macro setting changes made in Excels Macro Settings section apply to Excelonly; they do notaffect any other Microsoft Office applications.1C H A P T E R 1Table 1-1 lists the Excel macro security settings and explains each setting.Table 1-1.Macro Security SettingsSetting PurposeDisable all macros without notification Use this setting if you dont trust the source of

a workbook containing macros.Disable all macros with notification This is the default setting. Use it when youwant macros to be disabled, but you want toget security alerts if there are macros present.You can decide when to enable those macros.Disable all macros except digitally signed macros This is the same as the Disableall macroswith notificationoption, except that whenthe macro is digitally signed by a trusted publisher,

8/10/2019 Livro 042111.txt

21/21

the macro can run if you have trustedthe publisher.Enable all macros (not recommended, potentially Use this setting to allow all macros to run.dangerous code can run)Trust access to the VBA project object model This setting is for developers only.nCaution The Enable all macrossetting makes your computer vulnerable to potentially malicious code.It is not recommended that you use this setting permanently. For the examples inthis book, we use this setting,but it is highly recommended that you choose another option in your production code.Trusted PublishersThis section lists the currently trusted certificates that can be used by developers to signdocuments and add-ins. When you open a digitally signed document, the digital signatureappears on your computer as a certificate. The certificate names the VBA projectssource,plus additional information about the identity and integrity of that source. A digital signaturedoes not necessarily guarantee the safety of a project, and you must decide whether

you trust a project that has been digitally signed. If you know you can always trust macrosfrom a particular source, you can add that macro developer to the list of trusted sourceswhen you open the project.Trusted Locations