Programming MS Project 2007 in C#

[asadim]

What would I need to be able to program Project Server 2007 in C#? I know
there's VBA but was wondering if I can do it in C#.

Thanks.

 

[Jim Aksel]

You will need Visual Studio 2005 with all the latest service packs and
hotfixes.
This is because the Office 2007 Objects (Office12) became available
afterward. Visual Studio is a robust programming development environment,
and quite a bit spendy.

Open a C# Project, You will need to reference the Project12 (or Office12, I
forget) library. You now have the objects you need. This would be
accomplished as a stand alone project or a DLL.

I am working something similar, but find it is a bit easier to find help
using VB.NET or VBA.

If this helps, please consider rating the response.

Jim

 

[asadim]

I decided to do it in VBA for now; however I can't figure out how to connect
to project server and retrieve a list of published projects. Here's what I
could put together after playing around with it for a few minutes:

dim p as project
for each p in application.projects
msgbox p.name
next p

This code only prints the name of the current project not all the projects
in Project Server. I have spent some time going through the objects and
functions in the VBAProjcet library but haven't found anything that solves
this problem.

Thanks.

 

[Rod Gill]

In Project Server 2007 you need to read the list of projects from the
reporting database (details in the project SDK downloadable free from
microsoft.com). Use oledb to read from the database.

In Project Server 2003 read directly from the MSP_VIEW_Projects table.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Brian Smith \(MSFT\)]

As an intro to Visual Studio and C# you could try the Express addition
available at http://msdn.microsoft.com/vstudio/express/visualcsharp/
downloadable for free. This will allow you to do most things and sample
from the SDK in C# will work well. Probably the only limitation you will
find is debugging server side events. The SDK can be found at
http://www.microsoft.com/downloads/...F9-7028-4B30-99A2-18CB1EED1ABE&displaylang=en.

If you do stick with VBA then you will find that Rod is very active on this
group and will answer any question you could possbly have.

Brian