XL-Dennis's Blog : .NET & Excel, Excel

SQLabs SQLite Tools

VSTO & .NET & Excel — Thu, 30 May 2013 15:42:13 GMT

We all get some favorite tools, tools that we use on a regular basis. They usually do the work fast and effective. I still use SQLite databases and have done it more then eight years or so. The SQLite database is great for a various tasks, especially as an embedded database. It’s easy to work […] Read More......(read more)

Time to move on – Exit MVP Program

VSTO & .NET & Excel — Sun, 07 Apr 2013 14:27:57 GMT

Around 2005 – 2006 I peaked with MS Excel, since then I have slightly moved away from it year to year. In 2010 I was honored to become part of Microsoft’s MVP-program. Of course, it was interesting to get another position and more closed to Microsoft in general, the production team in particularly. However, I never [...] Read More......(read more)

MarieDB

VSTO & .NET & Excel — Sun, 31 Mar 2013 12:12:35 GMT

How many know about the database MarieDB? The database is growing faster and faster. It takes market shares from MySQL. Why just from MySQL? MarieDB is a drop-in replacement for MySQL. It means that we can access and work with as it was a MySQL database. The differences between them are improvements made in MarieDB. [...] Read More......(read more)

Combinatorics Using Excel Formulas

VSTO & .NET & Excel — Thu, 28 Mar 2013 18:45:11 GMT

I have the honor to know Roberto Mensa via Linked In. He is strongly committed to explore, develop, improve and to discuss formulas in Excel. The site is fully dedicated to Excel formulas. Of course, he is not alone. There are some other people that make very good contributions too. He has named his virtual [...] Read More......(read more)

Clean Up!

VSTO & .NET & Excel — Sun, 24 Mar 2013 19:52:19 GMT

As part of my maintenance, in order to keep the computer fresh, is to regular run the built-in tool Free up disk space. The tool is accessible via the following commands: Start Button > Control Panel > System and Security > Administrative Tools > Free up disk space After running it the following dialog is [...] Read More......(read more)

Office Developer Tools for Visual Studio 2012

VSTO & .NET & Excel — Mon, 04 Mar 2013 21:29:37 GMT

Great news! Microsoft have announced today that the RTM version of Office Developer Tools for Visual Studio 2012 has been launched. For more information please read the following entry at Somasegar’s blog: Now Available: Office Developer Tools for Visual Studio 2012 Enjoy! Kind regards, Dennis Read More......(read more)

Windows 8 – News and Solutions

VSTO & .NET & Excel — Thu, 28 Feb 2013 15:18:36 GMT

SamLogic have recently published some articles at their blog about Windows 8 and the news for it. Personally I have difficulties to work with Windows 8. Maybe I’m too old and simple don’t understand how wonderful the new UI actually is. One thing we know for sure, when Microsoft designed Windows 8 it was not [...] Read More......(read more)

POEditor: An Excellent Translation Tool!

VSTO & .NET & Excel — Fri, 22 Feb 2013 15:27:41 GMT

It’s very exceptionable that I get thrilled over a software. The last time must be the first version of Excel 2.1d, that’s nearly 30 ago, I got in my hand! I can only say that it’s an excellent software and it’s also free. It’s so good that I say its speak for itself. The URL to POEditor [...] Read More......(read more)

Black clouds over MS Office 2013

VSTO & .NET & Excel — Thu, 21 Feb 2013 14:47:01 GMT

I’m getting worried over what’s going on. For every new version of Office and Excel there has been a positive tone in the online community and an excitement with the new features. But that’s not really true with MS Office 2013. The terms to use a license shrink and some features are no longer available in some [...] Read More......(read more)

Ninja WinRT Database Released

VSTO & .NET & Excel — Mon, 04 Feb 2013 19:41:42 GMT

For the larger group of developers the vendor Kellerman Software may be an unknown vendor. Time to change it. For the last couple of years I have been using components for developing managed COM solutions for MS Excel. The components are great and do the work well. Now Kellerman Software has released their first version [...] Read More......(read more)

SamLogic Visual Installer 2012 available in English!

VSTO & .NET & Excel — Wed, 09 Jan 2013 01:18:28 GMT

In some earlier blog articles I have written about and mentioned Visual Installer 2012 from SamLogic, a Swedish Company. The key feature for Excel developers is that Visual Install 2012 can create professional installation programs for all Excel files and in particular for native add-ins as it can both install/activate as well as uninstalling add-ins [...] Read More......(read more)

Support for Small Business by Microsoft

VSTO & .NET & Excel — Thu, 20 Dec 2012 17:29:54 GMT

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 [...] Read More......(read more)

Tools for MS Excel 2013 Development

VSTO & .NET & Excel — Fri, 07 Dec 2012 12:12:18 GMT

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. Download: Excel 2013 SDK: Excel 2013 XLL Software [...] Read More......(read more)

Axialis Pure Flat 2013 Toolbar Stock Icons Rock!

VSTO & .NET & Excel — Sat, 10 Nov 2012 00:00:27 GMT

A software program’s success is usually depended on its functionality, i.e. it does the work and it has a user-friendly UI. In fact, the UI is the most important part of applications as that is what the end-users see and work via. This is something we all known (or at least should know). Among the [...] Read More......(read more)

VS 2012: A disaster for VSTO Developers?

VSTO & .NET & Excel — Thu, 01 Nov 2012 19:33:22 GMT

I thought I would get on with the blog much faster than I have done. Visual Studio (VS) 2012 has been out now for some time but still it’s ‘a new kid in town’. First I thought I would make some kind of a walkthrough for the news in VS however I ended up turning down [...] Read More......(read more)