Patrick’s Bytes

When you try to install a ClickOnce VSTO application you got the follow error saying your .NET Framework version is not correct (however Windows 7 ships with .NET 3.5 SP1)

Thanks to a blog post from the VSTO product team, I realize that Windows 7 RC left our a file in C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.5\RedistList

When I start up my Windows 2008 VPC, I see there is a FrameworkList.xml file inside

So I copy it out from my VPC, then I restart Visual Studio (it is not mentioned in the blog) and republish the VSTO app. The installer is now working!

Today there is no build in support for SharePoint found inside Visual Studio 2008 except the SharePoint workflow project. If you want to create studd like Site Definition etc. you need to download the Windows SharePoint Services 3.0 Tools for Visual Studio. It is available for VS2005 as well as VS2008. So in TechEd EMEA 2008, Microsoft announced that Visual Studio 2010 tools for SharePoint will be build in for VS2010.

Channel 9 did an interview with Reza Chrisaz on what are the new features in VS2010 for SharePoint developers. You can download the video here.  I list down some of Reza’s Key callouts

 
SharePoint project templates build-in for VS2010

 
At last!! Visual designer for SharePoint webparts!!

Exploring SharePoint artifacts inside Server Explorer

Package Explorer - sort of like the one we have with VseWSS today

 
One of my favourite feature - the feature explorer

Adding Solution to TFS source control with Team Build and nightly build support

It has been sometime since there is an issue of MSDN mag that focuses on Office Business Application development. I believe not since before Visual Studio 2008 released. Visual Studio 2008 does comes with a lot of new tools inside VSTO for OBA development and it is worth while to have a look what you can achieve easily here.

Editor’s note on why one should think of Office as a development platform http://msdn.microsoft.com/en-us/magazine/cc507637.aspx

Document Automation using VBA to VSTO
http://msdn.microsoft.com/en-us/magazine/cc507643.aspx

Automate Web App Deployment with the SharePoint API
http://msdn.microsoft.com/en-us/magazine/cc507633.aspx

Integrate VSTO with SharePoint Content Types
http://msdn.microsoft.com/en-us/magazine/cc507632.aspx

While I am helping Tang to do a S+S Outlook addin, his customer is looking at integration with a back end database and also simple workflow.

Developing such an addin for Outlook 2007 would have easy with the Outlook 2007 S+S blueprint but the customer still running Outlook 2003. Late last night I managed to dig thru MSDN and found an article showing me just how to do it with Outlook 2003 and Visual Studio Tools for Office. http://msdn2.microsoft.com/en-us/library/aa537181.aspx

As per screenshot above, it shows you how to add a custom command bar into Outlook, and also how to trigger Windows Form from Outlook. But the cool thing here is the sample showing you how to create a custom folder under Inbox showing your own set of data. While not as slick as what you can do in Outlook 2007, it is good enough for most people out there.

The slides from ODC 2008 are made available on the OBA Central website.

The slides are categorized into a few categories:

• Architecture (those planning a full scale deployment of OBA should read this!)
• Client (incl. coverage of some lesser know product for OBA i.e. Access & Groove)
• Executive
• Server (ala SharePoint, look out for stuffs on BI and Authentication)
• Services (SOA & S+S)

One of the cool thing I saw from the slides is a 3d Silverlight webpart for Plant Floor OBA RAP (pic below).

http://www.obacentral.com/ODC

Today I struggled for some time to figure out how to control the visibility of custom task pane in Excel 2007. I had done quite a few Word 2007 addin projects but this is the first time I try to do it in Excel.

In Word 2007 with VSTO 3.0 (that comes with VS2008) to hiding the custom task pane I would add this in the Click event code

Me.Application.TaskPanes(Word.WdTaskPanes.wdTaskPaneDocumentActions).Visible = False

But with Excel 2007 it is different. You have use the DisplayDocumentActionTaskPane class

Me.Application.DisplayDocumentActionTaskPane = False

I found the solution in the MSDN article here.

Just FYI, adding a action pane is same for both application using the following method

Me.ActionsPane.Controls.Add(actions)

Just came back from Krabi today and the first thing that caught my eye when I open up Live.com homepage for the 1st time since 5 days is a sample ERP applications that make practical use of Windows Presentation Foundation framework without just snapping just another colossal.

The Lawson M3 Smart Client

Look at it, it is a familar interface like our normal Windows Form app but it gives end users a fresh feel which I think they will be happy to open and use everyday. And if you want to integrate this into Office task panes as a WPF add in, you can do so easily with VSTO 2008 as I mentioned here.

By the way, should you try to get away by saying there is no ‘design’ guy in your team/ company, a company called reuxables is making one of their WPF theme available free in the form of a .dll file. Download it here.

There is a few new options to deploy an Office addin in Visual Studio Tools for Office 3.0. Among them are creation of a setup.exe file, or via click once.

Here I how to create a .msi deployment file so that it can be built on a CD.

1. Right click on the project file and select Publish

2. Then you will see a wizard pops up, for this I enter a file path

3. Next I select CD-ROM as installation path to end users

4. On the next path, I click Finish

Now wait for the building process to be done, and you can open the deployment folder. For developers coming from previous VSTO they are understand how easy is it now to create deployment files for their VSTO projects.

Now when I click on setup.exe, the VSTO installation wizard will pops up

When I click Install, it will auto install itself without asking further question, huge improvement for end users and IT admin alike!

Beta 2 of Orcas just got release today and is downloadable either in VPC form or a DVD image. If you are based in South East Asia, where else to learn from experts about Orcas except TechEd 2007 South East Asia. There is the good old developer track and the newer web development track and their sessions have a lot of  materials on Orcas.

Web Development and UX Track
Getting Started Building Rich Interactive Apps with Silverlight
Deep Dive into Silverlight 1.1. with .NET

Developer Technology Track
Windows Client .NET: Building Rick Client UI with Acropolis Framework
Workflow in real world & how MS leverages workflow technologies
What’s new for device developers in Orcas
A lap around VS Orcas
LINQ and XML Integration in VB Orcas

You can have a look at the full list here.

Eric Carter been blogging about new VSTO features inside Visual Studio 2008 (Orcas), among them are

• New Document Level Office Project Type
• Sharepoint Workflow Project Type
• Mixing VBA and VSTO .NET managed code
• And there are many post about OBA and mashups as well.