VSTO & .NET & Excel

October 25, 2009

The New Package; Windows 7, VS.NET 2010 and Office 2010

Filed under: .NET & Excel, COM Add-ins, VSTO & Excel — Dennis M Wallentin @ 1:55 am

To create a workable structure I have always grouped individual new versions of Windows, VS.NET, VSTO and Office together. The present groups I work with are:

  • Windows XP, VS.NET 2005, VSTO 2005 SE, SharePoint 2003 and Office XP/Office 2003
  • Windows Vista, VS.NET 2008, VSTO 3.0, SharePoint 2007 and Office 2007
  • Windows 7, VS.NET 2010, VSTO 4.0 SharePoint 2010 and Office 2010

The list also reflects my different configuration guest systems on the VMware platform. I have recently replaced Windows Vista 64-bit with Windows 7 64-bit as my host system. The grouping can also be said to represent the optimal situation where we develop solutions with the .NET/VSTO version included targeting the Office version(s) included. At least that is my experience.

While Windows 7 RTM has been released VS.NET 2010 and Office 2010 are still in the beta stage as of this writing. Beta 2 of VS.NET 2010 came out this week while Office 2010 officially still is in beta 1. To complete the picture; Exchange 2010 RTM seems to be around the corner and SharePoint 2010 will soon be in the beta stage.

I have been taking part of the Office beta testing but only for Excel. I have no intention to make any walkthrough about what is new in Excel 2010. It already exist a great number of blogposts and sites that cover all the news in detail like Microsoft Excel Team Blog and Microsoft Office 2010 Engineering

As for the operating system the real successor to Windows XP is Windows 7 and not Windows Vista . The later will probably get the same position as Windows ME already have in all history books. With Windows 7 we get a modern operating system, with more secured network functions, a flexible User Acess Control (UAC) together with a new folder system and improved tools for music and video. Despite all the new “whistle and bells” it is as fast as Windows XP for all kind of operations, including file operations. 

The news in VS.NET 2010 is nearly all about SharePoint developing. VB.NET has also been improved and among other things working with Collection and Array Initializers have been improved and added. As for the other languages I have not been testing anyone of them. The major news in the Beta 2 version is that VSTO 4.0 now is included. At present I’m evaluating VSTO 4.0 so I will get back to it in an upcoming blogpost.

Office 2010 includes news for all the softwares in the suite and will also be better integrated with SharePoint than any previously version. With Office 2010 we also get a new Web based Office suite. My major concern is Excel 2010 desktop version so the other tools as well as the Web based suite are less important to me. Unlike Office 2007 we now can customize the Ribbon UI via a built-in UI and Outlook 2010 has now also fully implemented the Ribbon UI. As a developer I was rather negative surprised when it turned out that we did not get any more events methods in code to control the Ribbon UI with. The Office Button has, together with its content, been revised and improved. The new programming language did not made it to this version so it looks like we will have to wait for Office 15.0.

For Excel 2010 the major news is that we finally have got a 64-bit version of it – Please see the discussion about the 64-bit version here: Excel 2010 – Now With More Bits!. With the 64-bit version it is possible to work with really large datasets which can consume more memory then 4 GB. The future will tell us to which degree we need to develop separated solutions for the 64-bit and 32-bit version of Excel.

Microsoft continues to develop the management of large datasets including data analyse, especially data visualization in Excel. Among the news in Excel 2010 are SparkLines and an improved Pivot Table tool including Slicers. The later allows us to filter data in real-time and when the data is updated so are the Slicers updated. The integration between Excel and SQL Server will in general be handle by the Business Intelligence tool (BI) Microsoft SQL Server PowerPivot for Excel which is an add-in to Excel 2010.

I must honestly say that Microsoft has managed to put the pieces together with the new versions and my overall impression of all the software are positive. Next year will be the year when Microsoft will have a complete updated versions of all the server platforms as well as the other software suites. That is impressive!

Kind regards,



  1. That’s a really nice review Dennis. Thanks for all the overview information as well as the links for more details.

    Great stuff, thanks


    Comment by Mike Rosenblum — November 6, 2009 @ 4:19 pm

  2. Thanks Mike 🙂

    I think VSTO 4.0 will be the major component of interest when VS 2010 is shipped.

    All the best,

    Comment by Dennis Wallentin — November 9, 2009 @ 9:24 pm

  3. Nice overview Dennis.

    By the way, the November “Feature Complete” CTP of SQL Server 2008 R2 is out today.

    These versions will include the Master Data Services elements (formerly Stratature) and the MPP system (formerly DAT Allegro).

    Looking forward to it all meshind together sometime around April/May 2010.

    I am liking PowerPivot, especially the new DAX functions, which will be enhanced in the soon to be released November CTP which will arrive around thesame time as the Sharepoint 2010 public beta.

    I can see a divide growing between 32bit & 64bit architecture. All my next dev builds will be 64bit now.

    Agree about Win 7 – I am very pleased with mine. I have actually managed to get away with never installing Vista 😉

    Kind regards,


    Comment by Will Riley — November 9, 2009 @ 11:42 pm

  4. Hey Will,

    Looking forward to take part of Your findings with SQL Server 2008 R2 which seems to be a powerful update.

    >>All my next dev builds will be 64bit now.

    Will you also target 64-bit clients as well?

    >>I have actually managed to get away with never installing Vista

    That’s indeed very impressive!

    Kind regards,

    Comment by Dennis Wallentin — November 10, 2009 @ 7:33 pm

  5. Really kool review Dennis!


    Comment by Pranav — December 28, 2009 @ 11:54 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Blog at WordPress.com.

%d bloggers like this: