Fabulous Adventures In Coding

Eric Lippert's Blog

Visual Studio Tools For Office: Using Visual Basic 2005 with Excel, Work, Outlook and InfoPath

Eric Carter and I are excited to announce that the Visual Basic edition of our book about Visual Studio Tools for Office is now available. I'd like to give a big thank-you to everyone who put their time, energy and enthusiasm behind this project, particularly my co-author (who, as always, did most of the heavy lifting.)

Visual Basic and Office programmability have gone together for a long time now and it was very important to us that we build a product that worked well for Office VBA programmers who want to move into the rich .NET world. It was therefore equally important that our book cover the particular needs of Visual Basic programmers. Sorting out whether we would have one book cover both C# and Visual Basic, or two books, and which one to do first was an agonizing process, but ultimately I think we made the right choices, and I'm thrilled with the result.

My only regret is that we couldn't make the title longer. I wanted it to be "Teach Yourself How To Build Professional Real-World Enterprise Solutions With Microsoft Visual Studio .NET 2005 Tools For Microsoft Office System 2003 Using Microsoft Visual Basic 2006 With Microsoft Excel, Microsoft Word, Microsoft Outlook and Microsoft InfoPath In Twenty-One Days In A Nutshell". Apparently that would have involved making the cover larger or infringing on a trademark or something, and it just wasn't feasible.

See Eric's recent blog post for more details about the book and where to download the code samples.

Published Monday, May 01, 2006 9:47 AM by Eric Lippert
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

JOSII said:

Eric

VSTO VB Edition of your book, page 549.  I can't get the code to work. The error says there are too many variables for new() .  This error regards the statement:

AggregateWorksheet = New Excel.Worksheet(hostItemProvider, _
   Me.RuntimeCallback, worksheet.CodeName, Me, worksheet.Name)

Trust Access to Visual Basic Project is checked in the VA Security dialog of Excel.

Can you help?  Thanks.

JOSII
May 19, 2006 3:03 PM
 

toolmaker said:

The link to source code on the Addison-Wesley site takes one to a Zip file with C# code, not VB 2005.  Is this an error or has the source code for VB 2005 not yet been released?

See http://www.awprofessional.com/content/images/0321411757/sourcecode/VSTO_Code.zip

Thanks for checking this out..
May 30, 2006 11:56 AM
 

Eric Lippert said:

The C# code is posted, the VB code, not yet.  I'll make an announcement here when it is posted.

May 30, 2006 1:07 PM
 

Joe said:

I read the VSTO book and it is great.  One thing that still has me baffled...

I created a Winform that is opened by Winform Startup with a group of textboxes to populate a worksheet in the workbook that opened the form.  For the life of me, I cannot figure out how to get a reference to that workbook / worksheet....

Any help?

The book does not spend a lot of time on Windows Forms (I think about a page).  Most of the Forms chapter is devoted to Winform Controls on the Excel Sheet.
July 6, 2006 7:00 PM
 

Pranav Wagh said:

our team is ordering the book !!

btw can you you please give me your opinion on http://blogs.msdn.com/pranavwagh/archive/2007/01/06/here-is-a-question.aspx

January 5, 2007 4:18 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication


© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker