The code in the book targets VBA (visual basic for applications) and .NET for the
features in the latest version of excel (excel 2003 at time of print), Sample code for
VBA and .NET (written as visual studio .NET projects) is provided online (see
author’s URL at top of this review). The samples are organised by chapter. Each
chapter use one main workbook as a starting point to provide instructions and
navigation.
This book is made up of four parts:
1. Learning VBA
• Becoming an Excel Programmer
• Knowing the Basics
• Tasks in Visual Basic
• Using Excel Objects
• Creating your own Object
• Writing Code for Use by Others
2. Excel Objects
• Controlling Excel
• Opening, Saving and Sharing Workbooks
• Working with Worksheets and Ranges
• Linking and Embedding
• Printing and Publishing
• Loading and Manipulating Data
• Analysing Data with Pivot Tables
• Sharing Data using Lists
• Working with XML
• Charting
• Formatting Charts
• Drawing Graphics
• Adding Menus and toolbars
• Building Dialog boxes
• Sending and Receiving Workbooks
3. Extending Excel
• Building Add-ins
• Integrating DLLs and COM
• Getting Data from the Web
• Programming Excel with .NET
• Exploring Security in Dept
4. Appendices
• References Tables
• Version compatibility
here is the link which i found during internet search
http://rapidshare.com/files/286602787/PeWVBN6.rar
features in the latest version of excel (excel 2003 at time of print), Sample code for
VBA and .NET (written as visual studio .NET projects) is provided online (see
author’s URL at top of this review). The samples are organised by chapter. Each
chapter use one main workbook as a starting point to provide instructions and
navigation.
This book is made up of four parts:
1. Learning VBA
• Becoming an Excel Programmer
• Knowing the Basics
• Tasks in Visual Basic
• Using Excel Objects
• Creating your own Object
• Writing Code for Use by Others
2. Excel Objects
• Controlling Excel
• Opening, Saving and Sharing Workbooks
• Working with Worksheets and Ranges
• Linking and Embedding
• Printing and Publishing
• Loading and Manipulating Data
• Analysing Data with Pivot Tables
• Sharing Data using Lists
• Working with XML
• Charting
• Formatting Charts
• Drawing Graphics
• Adding Menus and toolbars
• Building Dialog boxes
• Sending and Receiving Workbooks
3. Extending Excel
• Building Add-ins
• Integrating DLLs and COM
• Getting Data from the Web
• Programming Excel with .NET
• Exploring Security in Dept
4. Appendices
• References Tables
• Version compatibility
here is the link which i found during internet search
http://rapidshare.com/files/286602787/PeWVBN6.rar
