Open MSPRoject file (server) from Excel

[Nde]

Hi,

I would like to open a project plan (published on MSProject Server) from
Excel.

I enabled the MS PRoject Librairy within Excel. I am able to open MSProject,
but just local not connected to the server.

I also tried to copy some code from MS Pro in Excel but it returns an error.

Code:
FileOpen Name:="<>\12199 CLA53-1 DEVADS LMIC System Shutdown.Published"

Errror :
Project cannot open the file

My guess is that I should have the server information between or in place of
<>. But I do not know the syntax.

Does anyone knows the syntax ?

Thanks.

 

[Rod Gill]

You have to have Project open and connected to Project Server, then the code
will work. If you are not logged in (local can't do it) then there is no
communication, no data transfer.

Another test: If you can't open a project manually, VBA can't either!!

--

Rod Gill
Project MVP

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

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Adrian]

If you are using Project Server 2007 there are two things to be aware of :-

1) You will HAVE to go through the PSA to communicate with Project Server
in any capacity.

2) Any user using this method MUST be appropriately licenced (that is
they will need a Project Server CAL) to access the data. (Same applies in
2003, although you can access the PS DB without usuing PDS in 2003, although
it is not recommended).

Regards

Adrian.

 

[Adrian]

Sorry I meant PSI not PSA !!

Regards

Adrian