Programming Excel with VBA & .NET

Programming Excel with VBA & .NET

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

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

[link Point to another website Only the registered members can access]

My threads; pw_12_x :

Hello
we are looking to hiring software programmers & petroleum engineers with a keen interest in maths & coding to support the development of engineering softwares.
Would you know where best to look for people with this background / capabilities

Discussion forum and a library of videos and photographs related to the petroleum industry.,www.egpet.net Website is Free Forum for Educational Purposes Only ,No files are hosted on our server,By using our services, you accept our terms of service.If there are any problem or complaints with one of the topics, please contact us....... Cookies help us deliver our services. By using our services, you agree to our use of cookies.