VSTO & .NET & Excel

February 14, 2012

From VBA to VB.NET using ExcelDna

Filed under: .NET & Excel, Excel, Tools, XLLs — Dennis M Wallentin @ 1:25 am

This is a notification about a recent published article by Patrick O’Beirne on his blog. Patrick has compiled a list of resources, for native Excel developers, to develop User Defined Functions (UDFs) with ExcelDna in VB.NET.

For some years ago several developers in the online Excel community made quite often critical comments and rant a lot about using .NET for developing Excel solutions.

Today the opinions are slowly changing to a more positive review of .NET which I welcome very much.

Here is the link to Patrick’s article: From VBA to VB.NET using ExcelDna

Of course, it exist other tools as well. For instance Add-in Express for Microsoft Office & .NET, which is a RAD tool that allows us to develop many different .NET solutions for Excel. Personally I prefer this tool than any other, it does all the hard work and allow me to set focus on the core in .NET solutions. It’s also the most powerful RAD tool and is unique.

Kind regards,


February 4, 2012

The Great Microsoft Office Portal

Filed under: .NET & Excel, .NET Books, Excel, Valentina DB, Valentina Office Server, VSTO & Excel, XLLs — Dennis M Wallentin @ 4:46 pm

As most of us already know, Microsoft has for the last couple of years built up an enourmus  giant knowledge base about Microsoft Office on the internet. As a consequence it has also become more difficult to navigate around and find the wanted information we are looking for.

However, today I discovered the Great Portal to Microsoft Office knowledge Base. Instead of just saving the URL to my local computer I thought I would make it more available by publishing it here:

Office Development Site Map

One of the key people for the ongoing publishing of Microsoft Office knowledge is Erika Erhli. I have previously related to her so this is a (very good) reminder:

Adventures with Office Products & Technologies

Do You remember how it was during the 90’s? At that time it was rather easy to be updated on a numbers of softwares from Microsoft. Today the softwares have become much more, more complex and more advanced and on top of that the release cycles have become faster.

So I’m glad that I, at least, can keep myself updated of Microsoft Excel. However, in the future we may only be able to keep up with the rapid development for one platform that Microsoft Excel is used on. What do You think?

Kind regards,

Blog at WordPress.com.