Browse by Tags

Time to move on – Exit MVP Program

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. However, I never [...] Read More...

Published Sun, Apr 04 2013 10:27 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET Books, VSTO Books, .NET & Excel, VSTO & Excel, SQL Server, Excel, XLLs, Apps for Office

Clean Up!

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 following dialog is [...] Read More...

Published Sun, Mar 03 2013 3:52 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, SQL Server, Excel, SQLite, Valentina DB, Apps for Office, Database, Spreadsheet components

POEditor: An Excellent Translation Tool!

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 URL to POEditor [...] Read More...

Published Fri, Feb 02 2013 10:27 AM by VSTO & .NET & Excel

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

SamLogic Visual Installer 2012 available in English!

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 install/activate as well as uninstalling add-ins [...] Read More...

Published Tue, Jan 01 2013 8:18 PM by VSTO & .NET & Excel

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

Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010

Microsoft have recently released a new version of its excellent tool, PowerPivot, for Excel 2010. It can be downloaded from Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010 Kind regards, Dennis Read More...

Published Mon, Aug 08 2012 6:43 AM by VSTO & .NET & Excel

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

New SQL Server 2012 Tools for MS Excel 2010

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...

Published Sat, Mar 03 2012 6:48 PM by VSTO & .NET & Excel

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

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

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

CEQuery Tool for SQL Server Compact Edition Databases

Background If You suspect that I, at present, work a lot with SQL Server Compact Edition (SSCE) databases than You are absolutely right about it. I have developed two larger solutions where SSCE databases are central parts of the respectively solution. In both projects data is exported to SSCE databases and then the data is [...] Read More...

Published Thu, Oct 10 2010 10:35 AM by VSTO & .NET & Excel

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

Create SQL Server Compact Edition Database with VBA

In a previously post I wrote about how we can retrieve data from a SQL Server Compact Edition (SSCE) database with ADO and Excel. Here I will discuss how we actually can create a database with VBA in Excel. In a coming post I will show how it can be done in VSTO which will [...] Read More...

Published Sat, Sep 09 2010 9:47 AM by VSTO & .NET & Excel

Filed under: SQL Server, Excel

Data Visualization – The PowerPivot Tool – Part I

Introduction With Excel 2010 around the corner I decided to make a blog series about visualizing data by using the new PowerPivot tool. My plan with the series is to present and discuss the PowerPivot. It will also include pointers to other online resources as well as to upcoming books where it’s appropriated. Anyway, let’s [...] Read More...

Published Sun, May 05 2010 6:55 PM by VSTO & .NET & Excel

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

Upgrading to SharePoint 2010

Now that I have managed to get a new MSDN subscription I’m about to upgrade my physical testserver with Windows 2008 R2 Server, SQL Server 2008 and SharePoint 2010. Despite all the good installation wizards included in the softwares it requires more knowledge and understanding then just click on the right buttons so to speak. [...] Read More...

Published Fri, May 05 2010 9:44 AM by VSTO & .NET & Excel

Filed under: .NET & Excel, SharePoint, SQL Server, Excel

Syndication

Recent Posts

Tags

Archives