-
Around 2005 – 2006 I peaked with MS Excel, since then I have slightly moved away from it year to year. In 2010 I was honored to become part of Microsoft’s MVP-program. Of course, it was interesting to get another position and more closed to Microsoft in general, the production team in particularly...
-
As part of my maintenance, in order to keep the computer fresh, is to regular run the built-in tool Free up disk space. The tool is accessible via the following commands: Start Button > Control Panel > System and Security > Administrative Tools > Free up disk space After running it the...
Posted to
XL-Dennis's Blog
by
VSTO & .NET & Excel
on
Sun, Mar 24 2013
Filed under:
Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, SQL Server, Excel, SQLite, Valentina DB, Apps for Office, Database, Spreadsheet components
-
Paradigma Software released version 5.0 of its Valentina Database and tools. The hard databases competition is an advantage for us developers; we get better tools and more for our money. Paradigma Software continue to offer some great tools for free; An updated and more powerful Valentina Studio which...
Posted to
XL-Dennis's Blog
by
VSTO & .NET & Excel
on
Mon, Mar 18 2013
Filed under:
Filed under: COM Add-ins, Tools, .NET & Excel, VSTO & Excel, Charts components, Valentina DB, Valentina Office Server, Real Basic Developing, Database, Spreadsheet components, VMWare
-
It’s very exceptionable that I get thrilled over a software. The last time must be the first version of Excel 2.1d, that’s nearly 30 ago, I got in my hand! I can only say that it’s an excellent software and it’s also free. It’s so good that I say its speak for itself. The...
Posted to
XL-Dennis's Blog
by
VSTO & .NET & Excel
on
Fri, Feb 22 2013
Filed under:
Filed under: COM Add-ins, Tools, .NET & Excel, VSTO & Excel, UI Design, SQL Server, Excel, XLLs, Installation Tools, Valentina DB, Valentina Office Server, Apps for Office, Database, Spreadsheet components, VMWare
-
For the larger group of developers the vendor Kellerman Software may be an unknown vendor. Time to change it. For the last couple of years I have been using components for developing managed COM solutions for MS Excel. The components are great and do the work well. Now Kellerman Software has released...
-
In some earlier blog articles I have written about and mentioned Visual Installer 2012 from SamLogic, a Swedish Company. The key feature for Excel developers is that Visual Install 2012 can create professional installation programs for all Excel files and in particular for native add-ins as it can both...
-
A software program’s success is usually depended on its functionality, i.e. it does the work and it has a user-friendly UI. In fact, the UI is the most important part of applications as that is what the end-users see and work via. This is something we all known (or at least should know). Among...
-
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...
-
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
-
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...
-
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...