XL-Dennis's Blog : COM Add-ins

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)

Great News From Paradigma Software & Syncfusion Inc

VSTO & .NET & Excel — Mon, 18 Mar 2013 13:47:33 GMT

Paradigma Software released version 5.0 of its Valentina Database and tools. The hard databases competition is an advantage for us developers; we get better tools and more for our money. Paradigma Software continue to offer some great tools for free; An updated and more powerful Valentina Studio which now also supports MySQL DB, PostgreSQL DB. [...] 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)

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)

COM Add-ins & Excel 2013: Important News

VSTO & .NET & Excel — Mon, 17 Dec 2012 14:03:47 GMT

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 [...] 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)

New SQL Server 2012 Tools for MS Excel 2010

VSTO & .NET & Excel — Sat, 31 Mar 2012 22:48:09 GMT

Microsoft has recently released a new version of their toolkit Data Mining for MS Excel. It’s for SQL Server 2012 and explicit target MS Excel 2010. To download it click on the following text: Microsoft SQL Server 2012 Data Mining Add-ins for Microsoft Excel 2010 In addition, Microsoft has released a new version of their PowerPivot tool [...] Read More......(read more)

VLOOKUP Week; Using VLOOKUP in VB

VSTO & .NET & Excel — Thu, 29 Mar 2012 13:49:45 GMT

Bill Jelen, MrExcel, has marked this week to honor the VLOOKUP function in MS Excel. Around the online Excel development community You will find contributions, usually blog posts, that gives various aspects for using or not VLOOKUP. I thought it would be interesting to create a case and see how VLOOKUP can be part of [...] Read More......(read more)

Remove Duplicates in VB

VSTO & .NET & Excel — Mon, 19 Mar 2012 13:42:49 GMT

I have some articles in the pipeline that shows how to achieve various tasks in MS Excel with VB.NET. It’s no rocket science but practical solutions for frequent tasks. The first article is this that covers how to remove duplicates from tables. To following screen shot shows the table before removing any duplicates: In the [...] Read More......(read more)

Add-in Express vs Visual Studio Tools for Office (VSTO)

VSTO & .NET & Excel — Thu, 01 Mar 2012 22:15:03 GMT

I recently stoped by at Add-in Express and noticed an interesting series of articles that compare their RAD-tool with VSTO. You may read themselves at the following URLs: Add-in Express vs. Visual Studio Tools for Office Add-in Express vs. VSTO: Version neutrality for your Office extensions Add-in Express vs. VSTO: Visual designers for Office Ribbon [...] Read More......(read more)