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

MSDN English Forum Assistant (Gadget)

During the summer Microsoft released a new tool, MSDN English Forum Assistant. It’s a gadget tool and it provides us with a shortcut to MSDN forums, i.e. we don’t need to use any web browser. The tool targets all visitors and makes it easy to ask questions, monitor threads or forums, access FAQs and search for knowledge. I have been using [...] Read More...

Published Wed, Sep 09 2011 11:20 AM by VSTO & .NET & Excel

Filed under: Tools, .NET & Excel, Excel, Search Tools

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

Reviews: PowerPivot Books

Introduction Life can be rather unpredictable; You go to bed and believes that the next day will be like the other days. But in the following day You find Yourself in a complete new situation. The situation can either be good but it also can be bad depending on how life’s dice are rolled. But, [...] Read More...

Published Wed, Mar 03 2011 3:55 PM by VSTO & .NET & Excel

Filed under: Tools, .NET Books, SQL Server, Excel, PowerPivot Books

Lotus Notes & Excel & VBA

First of all, a belated happy new year to everyone who regular visit my blog. I hope to continue to feed the blog with interesting material also under the year 2011. We are up to some challenges now that corporates tend to roll out Windows 7 and Office in a wider scale. Anyway, last year [...] Read More...

Published Thu, Jan 01 2011 4:51 PM by VSTO & .NET & Excel

Filed under: Tools, Developer sites, Excel

Riley’s Great Series: Dynamic OLAP Cube Reports in Excel

My good friend Will Riley posted last month on his blog a very good series about creating Dynamic OLAP Cube Reports in Excel. The series is in three parts and walk us through the required steps in order to create this type of reports. In addition to its main purpose the series shows clearly, at [...] Read More...

Published Thu, Dec 12 2010 1:45 PM by VSTO & .NET & Excel

Filed under: Tools, .NET & Excel, VSTO & Excel, .NET SQL Tester, SQL Server

Ribbon UI: SyncFusion’s Essential Tools & Professional-Icons.com

From time to time I come to think of how important it is with a user-friendly and professional Graphical User Interface (GUI). Of course, this is something that every developer sooner or later finds out themselves. What matters and what clients usually see is the GUI that the technical solutions are wrapped in. In this [...] Read More...

Published Wed, Dec 12 2010 1:14 PM by VSTO & .NET & Excel

Filed under: Tools, .NET & Excel, VSTO & Excel, UI Design, Excel

Improve Your VBA code with TM VBA Inspector

Recently Thomas Möller (TM) made a blog entry about his free utility, TM VBA Inspector, at Microsoft Access Team’s blog. Since it looked interesting I downloaded it and tested it with Access 2010. I than made a comment at the blog about porting it to other tools in the Office suite, especially to Excel, as [...] Read More...

Published Thu, Oct 10 2010 7:28 PM by VSTO & .NET & Excel

Filed under: Tools, Excel

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

This is the second article about creating XLLs with Add-In Express.NET and it will focus on creating a Setup package for our solution. The first article about it can be viewed here. Creating a Setup package is also very easy and straightforward with the Add-in Express.NET tool; we add a Setup project to the solutions. [...] Read More...

Published Mon, Aug 08 2010 7:12 PM by VSTO & .NET & Excel

Filed under: Tools, .NET & Excel, XLLs

Information about ExcelKB

Since 2004 I have been running ExcelKB where I have posted articles about Excel and .NET/VSTO on a regular basis. Overall it has had a quite a number of visitors and also a great number of page views. Under all these years I have paid for the service of using a Microsoft SQL Server database to handle all [...] Read More...

Published Mon, Mar 03 2010 12:35 PM by VSTO & .NET & Excel

Filed under: Tools, .NET & Excel, VSTO & Excel, XL-Dennis' freewares, SQL Server, Developer sites

Install and Activate Add-ins in Excel with Visual Installer

In the first part of this post I discuss how to work with the collection of add-ins as well as individual add-ins in Excel when using VB.NET/VSTO. In the second part the installation tool Visual Installer will be discussed in terms of installing and activating native add-ins in Excel. Part I – Add-ins When working with add-ins we [...] Read More...

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

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

Excel Loader New Version Released

Excel Loader is a free standalone utility that let the user choose which add-ins should be loaded or not when launching Microsoft Excel. I have updated the utility so it can run on Windows Vista and Windows 7 as well. The new version will also work with Excel 2010 once it’s out on the market. The next version of the [...] Read More...

Published Sat, Aug 08 2009 6:49 PM by VSTO & .NET & Excel

Filed under: Tools, XL-Dennis' freewares

AddInSpy - The missing diagnostic tool!

I thought that I should flag for the new diagnostic tool, AddInSpy, from MSFT. I have only started out to test it but I already like what I see. It can be a valuable source to detect present status for individual COM add-ins of all kind, i.e. managed, VSTO and unmanaged and provide a great number of values. The [...] Read More...

Published Wed, Oct 10 2008 1:59 PM by VSTO & .NET & Excel

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

Everyone or Just Me?

When we install new software we usually are given the options to either install it to “Everyone” or “Just Me”. Under normal conditions this is not an issue but suppose that we only want to install the software to either the person (”Just Me”) who installs it or to everyone who will be using the computer? In the first case, i.e. “Just Me”, it’s [...] Read More...

Published Sun, Sep 09 2008 6:28 PM by VSTO & .NET & Excel

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

Learning LINQ

At present my time table does not permit me to explore new things so I have postponed delving into some areas to the next year. However, in some cases I have made some research to get access to interesting sources and tools which I hope will help me out. LINQ is one area that is of high interest which may replace SQL within [...] Read More...

Published Sun, Sep 09 2008 6:27 PM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel, COM Add-ins, Tools, SQL Server 2000/2005

Syndication

Recent Posts

Tags

Archives