XL-Dennis's Blog

New SQL Server 2012 Tools for MS Excel 2010

2012-03-31T22:48:09Z

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

2012-03-29T13:49:45Z

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

2012-03-19T13:42:49Z

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)

2012-03-01T22:15:03Z

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)

From VBA to VB.NET using ExcelDna

2012-02-13T23:25:01Z

This is a notification about a recent published article by Patrick O’Beirne on his blog. Patrick has compiled a list of resources, for native Excel developers, to develop User Defined Functions (UDFs) with ExcelDna in VB.NET. For some years ago several developers in the online Excel community made quite often critical comments and rant a lot about using .NET [...] Read More......(read more)

The Great Microsoft Office Portal

2012-02-04T14:46:04Z

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

2012-01-30T12:43:28Z

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!

2012-01-22T23:23:13Z

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

2011-12-20T23:43:32Z

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

2011-12-15T13:11:20Z

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!

2011-11-08T14:43:32Z

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

2011-11-07T23:42:33Z

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

2011-10-27T15:43:30Z

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

2011-10-14T16:24:39Z

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

2011-10-06T12:47:36Z

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)