-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
Posted to
XL-Dennis's Blog
by
VSTO & .NET & Excel
on
Mon, Jan 30 2012
Filed under:
Filed under: COM Add-ins, Tools, .NET & Excel, VSTO & Excel, SQL Server, Developer sites, Excel, SQLite, Valentina DB, Valentina Office Server
-
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...
-
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...
-
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 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...
-
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...
-
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...
-
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 [.....
-
Recently I worked on a project that required to detect if a 32-bit operating system were running or not. Initially I thought it would be necessary to read from the Windows Registry but it turned out to much easier then that. The following snipped code requires VS 2010 and that we use .NET Framework 4...
-
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 [......