Browse by Tags

Best Practices Export Data to Excel

If You’re a VBA Developer You should know what best practices is to export data to MS Excel. Two expressions summarize it; Microsoft ActiveX Data Object Library and CopyFromRecordset. However, if You’re a .NET developer and face a situation where You must find a solution to export data to MS Excel then there is a [...] Read More...

Published Mon, Jan 01 2012 7:43 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, Tools, .NET & Excel, VSTO & Excel, SQL Server, Developer sites, Excel, SQLite, Valentina DB, Valentina Office Server

Paradigma offer Valentina Office Server 5.0 for free!

Paradigma announced today that they will offer the next version (5.0) of their Valentina Office Server for free. The offer targets certain groups of users, including Small and Medium sized companies, and for certain tasks. Not only that, under the same license conditions they also offer Valentina Studio + Valentina Report for free together with any [...] Read More...

Published Tue, Nov 11 2011 9:43 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, Excel, SQLite, Valentina DB, Valentina Office Server

Help & Manual – A Help Authoring Tool

In the past it was not common that small tools, for instance add-ins to MS Excel, included any help at all. Many developers thought that their utilities were, more and less, self-explanatory. Today we have become more professional in that almost all kind of tools include help or pointers to sites where the help is [...] Read More...

Published Wed, Aug 08 2011 9:02 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, Tools, .NET & Excel, VSTO & Excel, Excel

Code Signing Tool

In my previously post I put in a nice word for COMODO Code Signing Certificate. In this blog entry I will introduce the tool, SignGUI to digitally signing solutions in an easy and smooth way. SignGUI is a graphical front end for Microsoft’s SignTool.exe console utility. It’s free and can be downloaded from Briggs Softworks. [...] Read More...

Published Thu, Jun 06 2011 5:04 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, Excel, Installation Tools

COMODO Code Signing Certificate

During the last couple of years security has become more important. Today it plays a central role in many businesses around the world. As external consults we must be aware of it but perhaps more important is that we support it in a way that actually add more security to their business. Through the years [...] Read More...

Published Mon, Jun 06 2011 2:38 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, Excel, Installation Tools

SuperOrca Tool

In a previously blog entry, The Orca Tool – A MSI Creator and Package viewer, I discussed the Orca tool for working with MSI Databases. The utility does its work so there is nothing to complain about. OK, one negative thing is that we must download the whole Windows SDK in order to get the [...] Read More...

Published Wed, Apr 04 2011 5:12 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, Excel, SQLite, Installation Tools

Populate TreeView Controls with Tables from SQL Server & Access Database by using ADOX

This is the third article on how to populate a TreeView Control with Tables, Views and Columns from a SQL Server database respectively from an Access database. The previously blog entries on this subject is: Populate TreeView Control with Tables and Columns from MS Access Database Populate TreeView Control with Tables, Views and Columns from [...] Read More...

Published Fri, Oct 10 2010 11:32 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, Excel

Office 2010 PIA Redistributable available for download!

I know that some developers have been waiting to get access to Office 2010 PIA Restributable. Although we can create our own IA some developers prefer to use the officially PIA from Microsoft. Today when I checked it up I was pleasant surprise to find out that the PIA package is now available for download. [...] Read More...

Published Thu, Sep 09 2010 12:23 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, Excel, XLLs

Creating XLLs with Add-In Express.NET – Part 1

Introduction Recently I had a discussion with a local colleague and friend about using third-party developing tools. He prefers to not use any other tools than Excel and VS.NET. In that way he says he gets 100 % control of the developing process. One of my main targets is to reduce the overall time the [...] Read More...

Published Thu, Jul 07 2010 11:00 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, Excel, XLLs

VSTO: Upgrade and port present projects to VS 2010?

As many of us Excel developers may be aware of (or should be aware of); VSTO is still under development and has not yet reached a mature stage although it comes closer for every new version. New features are being added frequently. The situation creates a degree of instability in the VSTO platform and is [...] Read More...

Published Mon, Jun 06 2010 12:57 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel

New Download Page for XL-Dennis Tools

As a consequence of the reconstruction of ExcelKB my free tools needed a new place. I decided to add a new page to this blog enabling everyone to download the tools: Download XL-Dennis Tools Kind regards, Dennis Read More...

Published Fri, Mar 03 2010 10:15 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET Books, VSTO Books, .NET & Excel, VSTO & Excel, XL-Dennis' freewares, SQL Server

The COM Shim Wizard for VS 2010 is available

Misha Schneerson has now made the Shim Wizard for VS 2010 available for download. What should be noted is that the new version is not officially released by Microsoft and it’s not officially supported. For more information please see COM Shim Wizards for VS 2010. In view of the fact that VSTO is getting better and better for [...] Read More...

Published Sat, Mar 03 2010 7:33 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel

Interim Solution: COM Shim Wizard for Excel 2010 64-bit

For some days ago Misha Sheerson published an article about using the present version of the COM Shim Wizard for the coming Excel 2010 64-bit. This is an iterim solution and we should expect a new updated version of the COM Shim Wizard when Excel 2010 has been launched. I must admit that I have been [...] Read More...

Published Fri, Feb 02 2010 12:52 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel

Populate TreeView Control with Tables and Columns from MS Access Database

Introduction Populating TreeViews controls with some data is a common task in various type of applications. One common task is to let an application scan disks for folders and files and then populate a TreeView control with the data in a hierarchical way. In the following example all the tables and their columns from a MS Access database will be added to a Treeview control. [...] Read More...

Published Tue, Feb 02 2010 2:15 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel

The New Package; Windows 7, VS.NET 2010 and Office 2010

To create a workable structure I have always grouped individual new versions of Windows, VS.NET, VSTO and Office together. The present groups I work with are: Windows XP, VS.NET 2005, VSTO 2005 SE, SharePoint 2003 and Office XP/Office 2003 Windows Vista, VS.NET 2008, VSTO 3.0, SharePoint 2007 and Office 2007 Windows 7, VS.NET 2010, VSTO 4.0 SharePoint 2010 and Office 2010 The list also reflects my different [...] Read More...

Published Sat, Oct 10 2009 7:55 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel

Syndication

Recent Posts

Tags

Archives

Best Practices Export Data to Excel

Paradigma offer Valentina Office Server 5.0 for free!

Help & Manual – A Help Authoring Tool

Code Signing Tool

COMODO Code Signing Certificate

SuperOrca Tool

Populate TreeView Controls with Tables from SQL Server & Access Database by using ADOX

Office 2010 PIA Redistributable available for download!

Creating XLLs with Add-In Express.NET – Part 1

VSTO: Upgrade and port present projects to VS 2010?

New Download Page for XL-Dennis Tools

The COM Shim Wizard for VS 2010 is available

Interim Solution: COM Shim Wizard for Excel 2010 64-bit

Populate TreeView Control with Tables and Columns from MS Access Database

The New Package; Windows 7, VS.NET 2010 and Office 2010