Category: Office Development

Office Development

Connecting MS Project 2010 to Project Web App

Home | Office Development | Connecting MS Project 2010 to Project Web App

I was trying to connect MS Project 2010 to a Project Web App (MS Project Server), got this error “.

pic1

The root cause of the issue was that, the MS Project 2010 was not able to connect to Project Web App using the logged on user’s credential.

I had to make a change to the following browser settings to get this working.

IE –> Tools –> Internet Options –> Security –> Intranet (in my case PWA site is hosted in intranet zone)

Custom Level –> User Authentication –> Logon –> Prompt for user name and password

pic2

 Subscribe to my blog

How to Install VSTA (Visual Studio Tools for Applications)

Home | Office Development | How to Install VSTA (Visual Studio Tools for Applications)

I was searching for an installer for VSTA (Visual Studio Tools for application). Looks like there is no separate installable for VSTA (Visual Studio Tools for application). After a bit of research, I’ve learnt that VSTA is embedded inside Office 2007 Professional or higher.  We can install VSTA by performing the following steps

Control Panel —> Office 2007 — > Change — > Add or remove features

This will display all the Office 2007 suite of products and its corresponding features

Each of the office products like Word, Excel and InfoPath etc has the support for .NET Programmability support.  By default the programmability support is not enabled. We need to enable Programmability Support for the relevant products. This would bring the necessary VSTA support for IDE and handles all the application-level events of office.  So VSTA becomes the logical replacement for the legacy VBAs.

 

 Subscribe to my post