VSTO & .NET & Excel

May 21, 2015

Time to move on

Filed under: .NET & Excel — Dennis M Wallentin @ 1:09 pm

First of all, thank You everyone who have made this blog by posting through the years. Nothing last for ever, except for Microsoft (!!), so this is the last post here on this blog. It will be available as long as WordPress allow it. I guess it’s due to inactive it will, sooner or later, be removed. What I’m doing? Well, coding in Xamarin (Android), NSBasic (Android), .NET, VB6 and occasionally in VBA.

As an amusement I want to publish the following info:


Happy coding all!

Kind regards,


August 13, 2014

Articles about installing softwares from SamLogic

I’m aware of the fact that I nowadays rarely make any posts here at all. One explanation is that I’m learning about new tools and that I find it very satisfaction and enjoyable.

Nevertheless, SamLogic, the Swedish vendor of Visual Installer and other excellent tools, have recently published some interesting articles which explain some important aspects when it comes to install softwares:


Happy coding everyone!


May 13, 2014

Free ApressOpen eBook: Office 365

Filed under: .NET & Excel, Excel, Tools, VSTO & Excel — Dennis M Wallentin @ 7:31 pm

I’m still alive although it was quite a long time ago I published any article here. But now that I’m back I hope I will speed things up so You will see more activity of my blog.

Apress have a series of books that are made available for free. The series is  named ApressOpen eBooks and it’s the publisher branch’s “open source” program.

It should be noted that the series only includes eBooks.

Recently Apress announced that, among other titles, the book Office 365 is now part of the series.

The start page for ApressOpen eBooks: http://www.apress.com/open-source

Here is the URL to the book’s page: http://www.apress.com/9781430265269


Kind regards,

January 13, 2014

VBA Enumeration Database

Filed under: .NET & Excel, Database, Developer sites, Excel, SQL Server, SQLite, Tools, Valentina DB — Dennis M Wallentin @ 3:24 pm

Whenever CodeProject send their newsletter I take the time to read it more carefully. Although not every time but quite often I find one or more gems among the presented articles.

The article VBA Enumeration Database should be read by every seriously MS Excel developer as it covers one of the cornerstones in VBA development; interaction with databases.

So I recommend You to click on the above URL, start to read and then download the code!

Please note, You must be a member of CodeProject to download.

Kind regards,

PS: I must confess; I have not written a single line of VBA code for the last 6-8 months. At least, what I can remember 😉

January 1, 2014

Syncfusion’s Free Offers

Filed under: .NET & Excel, Apps for Office, COM Add-ins, Excel, SQL Server, SQLite, Tools, UI Design, Valentina DB, VSTO & Excel — Dennis M Wallentin @ 8:37 pm

During 2013 Syncfusion have been releasing additional books in the series of Succintly. They cover a lot of development areas and are all free (PDFs).

Not only books are shipped free. Syncfusion offers also for Hobbyist the Essential Studio for JavaScript.

Per se it’s not free as You need to pay $ 1 for 1 license which is also valid for next offer.

Another offer for Hobbyist  is the Essential Studio for WinRT (Windows 8.1)

The JavaScript Studio should attract Excel developers who develop so called Office Apps.

Anyway, I find it nice when a company like Syncfusion actually see the group of hobbyists.

Yes, I’m a full member of the Hobbyists group 😉

Happy Coding!


December 9, 2013

Load and Help: SoftMaker’s FreeOffice suite

Filed under: .NET & Excel — Dennis M Wallentin @ 2:16 pm

SoftMaker have a yearly tradition, Load and Help, where they offer a free version of their Office suite, FreeOffice for the Windows platform and also the Linux platform.

This time the free package also includes a group of nice fonts.

For every download SoftMaker will pay € 10 to aid and charity projects around the world.

For more information please go to Load and Help site.

I find it to be a very nice approach and therefore give it my support.

Kind regards,

November 19, 2013

Add-in Express Series for Excel Beginners

Filed under: .NET & Excel, Apps for Office, COM Add-ins, Excel, SQL Server, Tools, Valentina DB, VSTO & Excel, XLLs — Dennis M Wallentin @ 7:51 pm

Add-in Express have published a great number of interesting articles for Excel beginners. To be more specific, Excel beginners who use their All-in Framework .NET to create COM Add-ins, RDTs and Functions Libraries (XLLs and UDFs).

Here is the link to the first article in the series:


Kind regards,

October 30, 2013

Crazy things at a Peer Support forum

Filed under: About Nothing — Dennis M Wallentin @ 12:23 am

Let me tell You a story of a Peer Support Forum that do things totally different then other forums do. It’s remarkable that it happens 2013 at an US-centric forum as the actions are more like to be find in a country without any democracy.

# Moderators correct the English in use, especially when non-US citizens make post.

I find it very abusing. It’s like treating non-US citizens as second class members. It’s the first time for me. after all the years in the online communities, that my English has been corrected. It was also the first time where I explicit was abused for my poor English.

# Moderators remove threads that are critical in some way to the product the forum is based on.

I simple lack word for it.

# Members of the forum can be black listed if they continue to be critical.


# Members who still not follow the rules are kicked out and blocked to access the forum.


If You want to view it You can access it via the following URL:

Of course, only customers to the product can be members.

In my next article I will discuss what customer service is for me and what it is for the company behind the product.

Kind regards,

PS: If You want to spell check this blog article it’s not possible.

October 11, 2013

Apps Launcher – Windows 8

Filed under: Tools, Xojo — Dennis M Wallentin @ 11:44 pm

I have been using Windows 8 for a while. As most of us know it’s primarily for touch screens which can create some issues on the desktop. Most softwares I use are usually placed on the Task bar. Up to Windows 7 it worked well out.

With Windows 8 I started to notice that I sometime cannot access the Task bar. In other words it’s not accessible. Perhaps I have not found out the right keys combination. Of course, an even better solution may be to skip the Task bar in the first place.

So I decided to create a small utility, App Launcher, where my favorite tools are available for me. The screen shot below shows the UI for App Launcher.


App Launcher is a test pilot. If things go well I will create a better tool that makes it possible to add/remove/replace tools. But at present I will test the App Launcher to find out if it suites me or not.

Is this kind of tool attractive for other users as well?

Edit: What I originally forgot to mention in this article is that with a (free) tool like App Launcher it will also be possible to start the tools with various start parameter(s).

Kind regards,

PS: App Launcher is created with Xojo.

September 3, 2013

Great Articles based on Formulas only!

Filed under: .NET & Excel — Dennis M Wallentin @ 5:54 pm

Whenever I see solutions in MS Excel without the use of VBA it actually reveals the core power with functions and formulas. That’s why I want to highlight the excellent work made up at “E90E50fx….only formulas”.

It says “…only formulas” however it exist at least one article that includes VBA. But they are forgiven 🙂

The following link will take You to the site: https://sites.google.com/site/e90e50fx/home

Now I will go back to other activities excluding MS Excel!


Kind regards,

Older Posts »

Create a free website or blog at WordPress.com.