Solved

VB Automation to Microsoft Project Server

Posted on 2006-10-19
9
199 Views
Last Modified: 2013-11-15
We have code that can access mpp files via the Project API.  Now we would like to do this with projects stored on Microsoft Project Server but don’t know how to establish the connection. Can you explain how and/or provide a reference to do this?
0
Comment
Question by:ErnestForman
  • 4
  • 3
9 Comments
 
LVL 10

Expert Comment

by:winzig
ID: 17769677
there are followin 2 methods:
1) Project Data services - Soap interface you can create new project , create new task , buil team prom enterprise , modify project properties but you can't modify existing tasks.
2) You can use Project Proffesional to connect to Project server and when you open the file you will be able work with it using Project Pro Objects
0
 

Author Comment

by:ErnestForman
ID: 17772944
I think you are close to the answer I'm looking for. I'd like to do 2) above but don't know how to specify the ADO connection string to Project Server to connect to the desired project. Can you give an example?
0
 
LVL 10

Expert Comment

by:winzig
ID: 17776721
Sub ttt()
Shell "C:\Program Files\Microsoft Office\OFFICE11\winproj.exe /s http://w2003project/ProjectServer/"

Dim oApp As MSProject.Application
Set oApp = New MSProject.Application
oApp.Visible = True
oApp.FileOpen Name:="<>\hokus pokus.Published"
End Sub

I don know how to control connectrion state from VBA code so i used  the SHELL command with switch /s
/s - URL
/u user name (for project auth)
/P password (for project auth)
0
 

Author Comment

by:ErnestForman
ID: 17778065
Can you explain what the shell command is doing? That is, what is the result of doing the shell?
Can you explain what the "<>\hokus pockus.Publsished" is supposed to be?

0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 10

Accepted Solution

by:
winzig earned 500 total points
ID: 17780322
the shell comand executes the MSProject application, the result of this code is that MS Project Pro is opened on your computer and is connected to MS Project server.

"<>\hokus pockus.Publsished"  is name of the project on project server, "<>\" means that this project is stored on project server.
0
 

Author Comment

by:ErnestForman
ID: 17783154
I think this is enough for us to give it a try.  Can you give me a reference to where information such as <>\ is explained.

Thanks,
Ernest
0
 
LVL 10

Expert Comment

by:winzig
ID: 17801641
I have no idea :) i found this convention in recorded macro.
0
 
LVL 30

Expert Comment

by:irwinpks
ID: 17972455
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept - winzig

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

irwinpks
EE Cleanup Volunteer
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Manage multiple projects with an overview of all 5 183
microsoft project 1 117
Functionality:  Waterfall vs. Agile 1 143
Scrum and Problem reports 1 158
Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now