Can VBA envoke Project server?

S

Steve Scott

We are considering deploying project server in our organisation. However at
the same time there is an initiative to create MSP schedules from Excel
estimating templates. I have seen this demonstrated and it essentially uses
some VBA from within an Excel workbook to open up MS project (2000) and
create a basic plan based on the estimate data.

If we were to move to Project Server ie where everyone is working on the
Enterprise template, could the above VBA be modified to send the data to a MS
Project file within Project Server or would be have to continue to do all of
this outside Project Server and then import the plans.
 
R

Rod Gill

See code above. Once logged in you can use what ever you do manually. Record
macros to get the slightly different formats for FileOpen etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA invoke MSP Server 1
Missing cached enterprise vba project 1
Reports 0
Sync between PWA-view data and data in the project data base 1
How to open a Project Server 2007 project plan from Excel VBA macr 1
Project Server 2007 and SSRS 2005 integration: issue withauthentication when running to the reports 3
VBA code to automatically (or automagically) populate a project teamfrom the same resources each tim 7
Enterprise Resources Dropped in Project Plan 0

Top