Programming Excel with VBA and .NET Jeff Webb, Steve Saunders
Publisher: O'Reilly Media

First, VBA is still the most relevant, widely used, and effective way to automate Excel, and nothing that Microsoft has said places that in doubt right now. A good book on spreadsheet programming. (1) from the VBA editor, reference mscorlib.dll (.net's core lib) (2) you can now do the following code. While VBA is the “traditional” way to automate Office, VSTO is the “modern” way. A Universal Application Settings Control for Excel VBA programes. As I wrote in the blog VBA Forever! The winner may get more future projects as result. By: Rob Bovey; Dennis Wallentin; Stephen Bullen; John Green. The second edition Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel, VBA®, and .NET, Second Edition. Publisher: Addison-Wesley Professional. €Gabhan Berry, Program Manager, Excel Programmability, Microsoft “The first edition of Professional Excel Development is my most-consulted and most-recommended book on Office development. This article explains how the table functions of the non-commercial .net library finaquant® protos can be called from within Microsoft Excel using VBA macros. Dim myobj As New MyDotNetClass. I have a piece of code that isn't cooperating in converting a VBA excel macro I have that is going into a VB .Net program. Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd ed.). VSTO uses programming languages from the NET Framework, most notably, C# and VB.NET. This is the forum to discuss the Wrox book Excel 2007 VBA Programmer's Reference by John Green, Stephen Bullen, Rob Bovey, Michael Alexander; ISBN: 9780470046432.