Pro Excel 2007 VBA (Apress, 2008).pdf
需积分: 9 168 浏览量
2009-11-07
22:46:16
上传
评论
收藏 8.58MB PDF 举报
this print for content only—size & color not accurate spine = 0.893" 384 page count
Books for professionals By professionals
®
Pro Excel 2007 VBA
Dear Reader,
Having spent the past ten years writing code for Microsoft Office products, I
jumped at the chance to write a book on VBA programming. Before moving to VB
6.0 and subsequently .NET, I was primarily focused on solutions for Microsoft
Access, but I’d always had a soft spot for Excel. After working through this book,
you’ll discover that the latest version of Excel (2007) offers a rich set of tools that
enable you to develop user-friendly data-centric applications. And I promise,
after you’ve dabbled in Excel programming, you’ll never look back.
In this book, I’ll show you how to leverage Excel to retrieve data from a database,
how Excel can read and write data from non-database sources like XML and text
files, and how Excel can be used as a data collection tool. And since Excel is an
integral part of the Microsoft Office suite, I’ll show you how easily it integrates
with the other Office products. You’ll also see that Excel makes an extremely
capable and extensible reporting tool. Excel is often overlooked as a solution,
since more powerful database tools such as Microsoft Access are available, but
as you’ll see in the pages of this book, Excel 2007 has plenty of uses of its own.
You don’t have to look very far to find a place for Excel in your work. If you
think back to how often users export data from reports they receive into spread-
sheets for analysis, you might see an opportunity to bring your reports directly
into Excel.
I hope that when you’ve finished working through the examples and recipes
I’ve provided in this book, you’ll agree that Excel 2007 provides an easy-to-use
yet extremely powerful programming environment. Data input, data output,
charts, reports, and integration—Excel does it all.
Jim DeMarco
US $42.99
Shelve in
Excel
User level:
Intermediate–Advanced
DeMarco
Excel 2007 VBA
The eXperT’s Voice
®
in eXcel VBa
Pro
Excel 2007
VBA
cyan
MaGenTa
yelloW
Black
panTone 123 c
Jim DeMarco
Companion
eBook Available
www.apress.com
SOURCE CODE ONLINE
Companion eBook
See last page for details
on $10 eBook version
ISBN-13: 978-1-59059-957-0
ISBN-10: 1-59059-957-8
9 781590 599570
5 4 2 9 9
Learn to build high-performance
applications in Excel 2007 using VBA
Pro
RELATED TITLES
剩余385页未读，继续阅读
资源评论
