Préface :
Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including covering all the new features in Excel 2007. Covering object–oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code. The book also covers XML for Excel web development. This book is unique insomuch that author Jim DeMarco is a true expert in the field of Excel programming, and he conveys the VBA story in the context of the real world. Not just another dry programming guide, Pro Excel 2007 VBA is a journey from novice to expert where the author is your traveling companion.
Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including covering all the new features in Excel 2007. Covering object–oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code. The book also covers XML for Excel web development. This book is unique insomuch that author Jim DeMarco is a true expert in the field of Excel programming, and he conveys the VBA story in the context of the real world. Not just another dry programming guide, Pro Excel 2007 VBA is a journey from novice to expert where the author is your traveling companion.
Introduction
Did you ever wonder whether there is more to Excel than data displayed in rows and columns
or 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 I’ve always enjoyed writing applications in Excel when it is the
required solution. Excel is often overlooked in coding situations, but as you’ll see in the pages
of 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 your
client spreadsheet data can be shared. Excel UserForms give you the ability to create simple
user interfaces for your clients and allow you to create easy-to-use data collection tools. Excel
charting and PivotTables have always been a strong suit for data summary, and in Excel 2007,
PivotTables are greatly enhanced.
This book also addresses object-oriented programming to a great degree. Just because
you’re not writing a .NET or even a classic Visual Basic application, there’s no reason you can’t
use object-oriented coding techniques in your projects. It provides you with the same advantages
in Excel that you get in the full-fledged programming languages: ease of reuse, easier
code maintenance, encapsulation, and more.
You will find sample files and code solutions in the Source Code/Download section of the
Apress web site, at www.apress.com.
Who This Book Is For
This book is intended for developers who would like to learn to use Visual Basic for Applications
(VBA) to extend the power of Microsoft Excel 2007. You should have some knowledge of
or experience using the VBA or classic Visual Basic programming languages and their related
development environment.
Anyone with VBA, Visual Basic, Microsoft Access, or .NET experience will readily understand
the concepts in this book, but anyone with any coding experience should have no
problem with the material.
Did you ever wonder whether there is more to Excel than data displayed in rows and columns
or 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 I’ve always enjoyed writing applications in Excel when it is the
required solution. Excel is often overlooked in coding situations, but as you’ll see in the pages
of 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 your
client spreadsheet data can be shared. Excel UserForms give you the ability to create simple
user interfaces for your clients and allow you to create easy-to-use data collection tools. Excel
charting and PivotTables have always been a strong suit for data summary, and in Excel 2007,
PivotTables are greatly enhanced.
This book also addresses object-oriented programming to a great degree. Just because
you’re not writing a .NET or even a classic Visual Basic application, there’s no reason you can’t
use object-oriented coding techniques in your projects. It provides you with the same advantages
in Excel that you get in the full-fledged programming languages: ease of reuse, easier
code maintenance, encapsulation, and more.
You will find sample files and code solutions in the Source Code/Download section of the
Apress web site, at www.apress.com.
Who This Book Is For
This book is intended for developers who would like to learn to use Visual Basic for Applications
(VBA) to extend the power of Microsoft Excel 2007. You should have some knowledge of
or experience using the VBA or classic Visual Basic programming languages and their related
development environment.
Anyone with VBA, Visual Basic, Microsoft Access, or .NET experience will readily understand
the concepts in this book, but anyone with any coding experience should have no
problem with the material.
Contents
DownLoad
No comments:
Post a Comment
We are delighted to interact with the post, but please
Terms of comment:
The comment must be within the context of the entry was not to put any external links or publicity even published commentary.