Blogs

Hi there! Many times it is a newsgroup post which triggers me to do a writeup on a specific subject. This time, a user asked how he could import a csv file every month, without having to go through the hassle of renaming the file and re-defining the import settings each time. Opening the file in Excel [...] Read More...

The VSTO development team recently announced that they has released a hotfix for Office 2007 so that we now can deploy VSTO solution to “All Users”. For Office 2010 it has been fixed while for Office 2003 it is left out. For more information please see Deploying your VSTO add-ins to All Users. To get the hotfix for Office [...] Read More...

In a previous mobile blog post , we briefly introduced our supported mobility scenarios in Office 2010. Those mobility functions rely on support from SharePoint 2010 mobility. Today’s post describes how to setup your SharePoint server environment so you can take advantage of mobile access. Microsoft SharePoint 2010 includes support for using feature phones to access documents, lists, calendars on SharePoint 2010, performing people and document searches and receiving SMS alerts on SharePoint content...

Since 2004 I have been running ExcelKB where I have posted articles about Excel and .NET/VSTO on a regular basis. Overall it has had a quite a number of visitors and also a great number of page views. Under all these years I have paid for the service of using a Microsoft SQL Server database to handle all [...] Read More...

Today’s post is just a quick status update to keep everyone in the loop on the progress Office 2010 is making, as well as to provide finalized details for our Office 2010 Technology Guarantee. Starting today, consumers who purchase and activate Office 2007 will be able to download Office 2010 at no additional cost when it becomes available in June 2010. All you need to be eligible for this program – Office 2010 Technology Guarantee – is the following: Purchase Office 2007, or a new PC with Office...

There was a recent contest with PowerPivot, see the details of the contest here: http://wildfireapp.com/website/6/contests/19877?order=recency&view_entries=1   There were some great PowerPivot reports submitted, including some from our MVPs: Bill Jelen created a “Tag Cloud & SmartArt Updated Via PowerPivot!” report:   Tushar Mehta created a “Visualize US population trends over the last 150 years” report: Check out all of the entries here: http://wildfireapp.com/website/6/contests...

A few weeks back we went through an overview of mobility scenarios in the post Mobility in Office 2010 . Today’s post describes how to search and look up information on SharePoint web sites with your mobile phones. There are various investments in SharePoint 2010 focused on enabling mobile experiences, including using Smartphones and feature phones to access documents, lists, calendars on SharePoint 2010, performing people and document searches, and receiving SMS alerts on SharePoint content. These...

Introduction This is the second blog post about populating a TreeView control. In the first blog post, Populate TreeView Control with Tables and Columns from MS Access Database, I used a MS Access database to populate a TreeView with its tables and related columns. In this blog post I will instead be using a SQL Server Database. The first example is [...] Read More...