XL-Dennis's Blog

The Great Microsoft Office Portal

VSTO & .NET & Excel — Sat, 04 Feb 2012 14:46:04 GMT

As most of us already know, Microsoft has for the last couple of years built up an enourmus giant knowledge base about Microsoft Office on the internet. As a consequence it has also become more difficult to navigate around and find the wanted information we are looking for. However, today I discovered the Great Portal to Microsoft [...] Read More......(read more)

Best Practices Export Data to Excel

VSTO & .NET & Excel — Mon, 30 Jan 2012 12:43:28 GMT

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......(read more)

New Q&A Forum for PowerPivot!

VSTO & .NET & Excel — Sun, 22 Jan 2012 23:23:13 GMT

With the release of Excel 2010 Microsoft released a new powerful tool, PowerPivot, to work with large datasets and reports. The beta of version 2.0 has been out for a while and it seems that Microsoft is about to ship the final version soon. Meanwhile, I was pleasant surprised to learn that Mr Excel has recently launched a public [...] Read More......(read more)

Real Studio – The Perfect Companion for SMEs

VSTO & .NET & Excel — Tue, 20 Dec 2011 23:43:32 GMT

Introduction In the beginning of this year I decided to explore Real Studio (formerly Realbasic, RS) which is a full featured cross-platform software development tool. With it we can create a wide range of applications, from small tiny utilities to enterprise applications that target Mac OS X, Windows, Linux and the web. Initially I had [...] Read More......(read more)

Excel Mashup, Java & HTML 5

VSTO & .NET & Excel — Thu, 15 Dec 2011 13:11:20 GMT

Microsoft has recently launched a new site that target how to create rich and interactive data mashups in Excel for use on the web. Technically speaking, we use the programming language JavaScript to interact with embedded Excel Web Application’s objects. For basic and small projects we can use auto generated JavaScript. For more advanced solution we [...] Read More......(read more)

Paradigma offer Valentina Office Server 5.0 for free!

VSTO & .NET & Excel — Tue, 08 Nov 2011 14:43:32 GMT

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......(read more)

Excel & Valentina Database

VSTO & .NET & Excel — Mon, 07 Nov 2011 23:42:33 GMT

Introducing the Valentina Database I thought I would introduce the Valentina Database (Valentina DB) with this article and discuss how we can connect to it by using ODBC, both in VBA and in VB.NET. For the last 11-12 months I have been using Valentina DB as an embedded database in all clients’ solutions where it [...] Read More......(read more)

Axialis Stock Icons For Toolbar & Ribbon

VSTO & .NET & Excel — Thu, 27 Oct 2011 15:43:30 GMT

I’m the first to admit that I have moved forward and backward when it comes to stock icons and which icons to use. The UI plays a critical role in all kind of softwares which means that we also need to consider what kind of icons to be used. With the introduction of Ribbon UI [...] Read More......(read more)

Articles about VB.NET & Excel

VSTO & .NET & Excel — Fri, 14 Oct 2011 16:24:39 GMT

This is an announcement that Siddhard Route (MVP VB.NET) is publishing articles about VB.NET and Excel on a regular basis on his blog. The articles cover several areas on how to manipulate Excel through automation. For more information please see: VB.NET and Excel Enjoy! Kind regards, Dennis Read More......(read more)

Evaluate Sheet Types & Copy Sheets with VB

VSTO & .NET & Excel — Thu, 06 Oct 2011 12:47:36 GMT

This post demonstrate how we can evaluate sheet types and how to copy sheets with VB. In other words, no rocket science. The following procedure is only for demonstration purpose. It shows how easy it is to evaluate what sheet types we have. It also demonstrate how to dimension an object array and how to [...] Read More......(read more)

Copy Worksheets with VB

VSTO & .NET & Excel — Thu, 22 Sep 2011 14:07:45 GMT

Recently I answered a question regarding how to copy several sheets from one workbook to another. I then realized that it may be of common interest to publish it here. Beside that I’m happy to post an article related to code. Here it is assumed that we automate Microsoft Excel where we open two workbooks, [...] Read More......(read more)

MSDN English Forum Assistant (Gadget)

VSTO & .NET & Excel — Wed, 14 Sep 2011 15:20:01 GMT

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......(read more)

Help & Manual – A Help Authoring Tool

VSTO & .NET & Excel — Thu, 11 Aug 2011 01:02:00 GMT

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......(read more)

Microsoft All-In One Code Framework

VSTO & .NET & Excel — Thu, 21 Jul 2011 22:37:06 GMT

The best way to handle knowledge is to make it available to its targeting main group of individuals. Public Q&A forums are one example that both store and regular add new knowledge to the public knowledge base. Another example is Microsoft recently approach to create and maintenance a centralized code sample library, Microsoft All-In One [...] Read More......(read more)

New Page for Mac & Excel

VSTO & .NET & Excel — Mon, 18 Jul 2011 21:43:44 GMT

Ron de Bruin has recently launched a new page on his side devoted to Mac & Excel. He aims to port all the VBA code for Windows & Excel located on his site to Excel on the Mac platform. This is a welcoming initiative and although the Mac Excel community is not that large they [...] Read More......(read more)