VSTO & .NET & Excel

September 25, 2006

The framework for the 1st case study

Filed under: .NET & Excel — Dennis M Wallentin @ 11:12 am

The first case study I plan to do for the coming weeks will be about creating an add-in that includes:

  • Creating a customized menu
  • Creating a customized toolbar
  • Using Application events
  • Using a connection to a SQL Server and
  • Retrieving data

In that way the case will cover what I consider to be a framework. In order to get Excel developers up to speed the case will include:

  • How to create the add-in with VBA and
  • Port the add-in to VB 6.0 to create a COM add-in
  • Port the add-in to VB.NET to create a managed COM add-in
  • Port the add-in to VSTO 2005 SEB to create a managed add-in

Is this OK? 

Later I will show how we can solve the issue of creating add-ins for Excel 2000 to Excel 2007.

Kind regards,
Dennis

Advertisements

8 Comments »

  1. Dennis, it sounds perfect. I think this should give us pure VBA’ers a good base on starting to move from one platform to another. 🙂

    Comment by Ken Puls — September 25, 2006 @ 4:22 pm

  2. Ken,

    Thanks for Your feedback and I will in my next post show the VBA case.

    I’ll propably add the Excel file in use to the post rather then posting the code. After all, the blog is about .NET & Excel 😉

    All the very from,
    Dennis

    Comment by Dennis Wallentin — September 25, 2006 @ 6:44 pm

  3. Dennis, this sounds perfect. 🙂

    I really look forward to reading it…

    Mike

    Comment by Mike Rosenblum — September 26, 2006 @ 7:16 pm

  4. I’ll be interested to see the SQL connection – 🙂

    Comment by Will Riley — September 27, 2006 @ 10:59 pm

  5. Hi Dennis,

    Congratulations on the blog, I look really look forward to reading your posts 🙂

    Comment by Andrew Engwirda — September 28, 2006 @ 3:57 am

  6. Hi Mike, Will and Andrew,

    Thanks for Your kind comments and interest 🙂

    I also expect that You all want to contribute with input on different subjects. After all, nowadays it’s impossible to be updated within all fields!

    I have started to create the tool for the case so the first post will be published next week.

    Kind regards,
    Dennis

    Comment by Dennis Wallentin — September 28, 2006 @ 9:21 am

  7. Hi Dennis,
    Looking good.
    re code addin, which you mentioned in the comments to the last post, you can use santaxhilter with word press, is this not what you ment?
    “I’ll be interested to see the SQL connection”
    Me to!
    and also the differance between VSTO and VS solutions

    Comment by Ross — September 28, 2006 @ 11:13 am

  8. Ross,
    Since this blog is, at present, hosted at WordPress it’s not possible to use any plug-in, i e they don’t allow it. The future will tell me if I should port the blog to one of my own topdomains and then I’m free to use whatever plug-ins I want.
    I’ve added to my ‘to do’-list to make a post about VSTO (pronounced as ‘visto’), VS and VSTA.
    Kind regards,
    Dennis

    Comment by Dennis Wallentin — September 28, 2006 @ 3:23 pm


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: