VSTO & .NET & Excel

December 20, 2012

Support for Small Business by Microsoft

Filed under: .NET & Excel, Articles, Excel, Small Business, Tools, VSTO & Excel — Dennis M Wallentin @ 7:29 pm

I’m happy to inform that Microsoft is developing and expand their services and support to small and medium-sized businesses (SMB). From my point of view this is most welcoming as this group of companies have been sidestepped for some time now by Microsoft, in favour to the group of enterprises.

I know that professional MS Excel consultants work on a daily basis with the SMB group. When Microsoft now start to build up a strong support for this group I’m convinced that the companies can increase their ROI when using Microsoft’s products. It will also help the Excel consultants group in that they now can point their clients to Microsoft’s support portal.

I’m also convinced that the group of Excel consultants can get some help from the portal themselves.

All in all, everyone can benefit from Microsoft’s venture on SMB 🙂

At present Microsoft is building up the portal so in the coming weeks we can find more and more information. Please add a bookmark for the new portal and make sure You check it out on a regular basis:

Support for Small Business

Enjoy it!

Kind regards,

December 17, 2012

COM Add-ins & Excel 2013: Important News

Filed under: COM Add-ins, Excel, Tools — Dennis M Wallentin @ 4:03 pm

In case You wonder; VB6, aka classic VB, is still in use 🙂 Developing VB6 based COM add-ins is still an option, especially when targeting Excel 2000 and onforward.

Microsoft has reported that Office 2013 does not include an important dependency file, Add-in Designer Object Library (msaddndr.dll).  If You use the Shared COM Add-in template then You need to distribute this file with the solutions.

For more details please see the blogpost: VB6 based add-ins may fail to work in Office 2013

It’s great that Microsoft actually publishes it but I don’t like the last section of the blog entry:

For the long term, if you are the developer of the add-in, please consider moving to newer supported ways of writing add-ins, such as Apps for Office or VSTO.

It’s obvious that Microsoft try to force us to stop developing with classic VB. Of course, in the long run classic VB is a dead technology as it does not support x64 versions of Office.

The issue is actually two folded. First, VSTO is only maintained and it seems that no more development of it will be made. To be honest, VSTO is a less successful poor development platform and very few developers actually use it. Apps for Office is, at best, in the beta stage and is, at present, of little practical use.

It’s worrying that Microsoft points us to technologies that suffer from various troubles and issues. At the same time Microsoft cut off classic VB; the Shared COM Add-in template is no longer shipped with Visual Studio.NET and does not support any longer Office 2007. In addition, Office does not include important files. Am I supposed to only use VBA? Is VBA future saved? Probably not.

My personal opinion is that Microsoft wants to drop MS Excel as a development platform. Does MS Excel 2013 represent the new era where MS Excel is only an end users’ tool?

Kind regards,

December 7, 2012

Tools for MS Excel 2013 Development

Filed under: .NET & Excel, Apps for Office, Excel, Tools, VSTO & Excel, XLLs — Dennis M Wallentin @ 2:12 pm

I just want to add an article that gives the URLs for downloading the SDK and the Toolkit for Apps for Office with Visual Studio 2012. It’s not easy to keep up the pace and find the required tools so this is also a reminder to myself.




Blog at WordPress.com.