VSTO & .NET & Excel

March 4, 2013

Office Developer Tools for Visual Studio 2012

Filed under: .NET & Excel, Database, Excel, SharePoint, Valentina DB, Valentina Office Server, VSTO & Excel, XLLs — Dennis M Wallentin @ 11:29 pm

Great news! Microsoft have announced today that the RTM version of Office Developer Tools for Visual Studio 2012 has been launched.

For more information please read the following entry at Somasegar’s blog:

Now Available: Office Developer Tools for Visual Studio 2012


Kind regards,



May 14, 2010

Upgrading to SharePoint 2010

Filed under: .NET & Excel, Excel, SharePoint, SQL Server — Dennis M Wallentin @ 3:44 pm

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.

One of the best online resources that can be found is Critical Path Training who provides some great articles about MOSS. In addition to the mentioned online resources in my blog article  SharePoint – The Start I would recommend to take a closer look into their excellent article SharePoint Server 2010 RTM Virtual Machine Setup Guide. To get access to it You need to create a new account at their site and the article can then be found under the Members section.

Microsoft has recently released the SDK for SharePoint 2010 which can be found at Welcome to the Microsoft SharePoint 2010 SDK. The Microsoft SharePoint Team has also recently published a blog article about available language packs to SharePoint. For more information please see the article Language Offerings for SharePoint 2010 Products.

At present I have no intention to look for new books that cover version 2010. I still have some chapters left in the books I bought the first time I set up the server.

The main reason that drives me to invest time with the SharePoint platform is, of course, the Excel Services. For me it’s still a compliment to develop custom solutions with Excel and with .NET (automation and add-ins).

Do You do any work with SharePoint and in particular with Excel Services? What is Your experience with the Excel Services?

Kind regards,

Edit Note:
The same day as this article was published Erika Erhli (MSFT) published a compiled list of online resources at MSDN for SharePoint 2010:  MSDN: Getting Started with SharePoint 2010 and SharePoint 2010 Advanced Developer Training

Andreas Glaser has had the kindness to update his great tutorial for installning SharePoint 2010 with SQL Server 2008 R2 and Windows 2008 R2 Server. For more information please see: Installing SharePoint Server 2010 on Windows Server 2008 R2 and SQL Server 2008 R2 – Part 1: Overview

February 14, 2009

SharePoint – The Start

Filed under: SharePoint, SQL Server — Dennis M Wallentin @ 2:01 pm

Last year I decided to learn more about Microsoft Office SharePoint Server (MOSS) and in particular Excel Services. Instead of setting up a VMWare configuration I decided to buy a physical server to which my developing machine will be connected to as the only client.  Because of my security approach none of these two machines have access to Internet. Yes, I’m the first to admit that I’m paranoid but that is the way it is.

I got a nice price for the server Fujitsu Siemens FSC PRIMERGY ECONEL 100 S2 and bought more memory so it now has 2 GB. The server has two hard drives and therefore I decided to use a RAID 0  solution so one drive mirror the other drive. Previously I only had a 2 port KVM Switch but now I needed a 4 port Switch so I can switch between my laptop, my development machine and the server. The model I selected was Athen CS1734B which is one of a very few KVM Switches that can work with Windows Server 2008.

I decided to use Windows Server 2008 x64 standard edition which also gives access to the Hyper V technology. Unless we have all the knowledge required to configure and running a server and installing all the softwares we need some helps. In my case I prefer printed books and the help I got is from the book “Windows Server 2008 A Beginner’s Guide“. It covers the most basic to install and configure a Windows 2008 server and is written in a understandable way.

Next, a SQL Server 2008 Express Edition was installed and it did not cause any problems at all.

Installing a MOSS 2007 server requires one important preparation, to set up 11 accounts with names and passwords. They are required for both the Windows SharePoint Services (WSS) and for the MOSS server. Andreas Glaser has published a nice installation guide; Installing MOSS 2007 on Windows Server 2008 and SQL Server 2008 . However, to understand more a book is required and I was recommended to use “Beginning SharePoint 2007 Administration” written by my fellow countryman Göras Husman. At present I have only started to read the book.

Finally, the only thing that remains to do is to learn more about MOSS and what we can do with its Excel Services!

Kind regards,

December 14, 2008

Back to school!

Filed under: .NET & Excel, SharePoint — Tags: , — Dennis M Wallentin @ 1:29 am

The recent financial crisis and the following ‘panic stop’ in the world wide economy have also reached my part of the world.  In my opinion all the Medias have this time successfully contributed to the recession status.

The first cut down among the costs (in my wallet) is to end my MSDN subscription. For several years I have subscribed to it and the subscription has giving me a lot of new knowledge as well as the opportunity to explore new tools. During the present circumstances it’s simple too expensive. I also expect that I will be forced to reduce the costs additional within the nearest future… 

During previously recessions I have taken the time to learn new things or add knowledge to my knowledge on various subjects. This time is not an exception and I have decided to set focus on Microsoft Office SharePoint Server (aka MOSS) and later on the Excel service that MOSS provides. In other words, MOSS will be on the agenda for 2009!

As for the blogging I have promised myself to post more frequently next year about Excel automation, managed COM add-ins and VSTO.

Finally, I want to wish all the readers of this blog a Merry Christmas and a Healthy and Prosperity New Year with the below picture. It was taken by me today around 14:00 at Storsjö’s beach (about 1 km from where I live).  At the time of taking the picture the temperature was around -12 Celsius.

Kind regards,

Create a free website or blog at WordPress.com.