How to connect Project to a profile

[Daniel]

Hello,
I’m using Excel to open and read several enterprise projects, but I can’t
figure out how to connect project to the server using VBA. When I run my
macro I got the message
“Project is unable to open the selected project. You selected a project
saved to Project Server while you are offline, etc.â€
So, currently, I open Project first in order to be online and then run my
macro. But it’s annoying when using Excel to be forced to run Project first.
So what can I do?
Daniel

 

[Rod Gill]

HI,

you need to start project using the Shell winproj.exe /s ServerAddress
command to start project Pro connected to a proejct server, then loop until
the connection is confirmed (test the result of the GetObject command - page
420 in my book).

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Hello,
I’m using Excel to open and read several enterprise projects, but I can’t
figure out how to connect project to the server using VBA. When I run my
macro I got the message
“Project is unable to open the selected project. You selected a project
saved to Project Server while you are offline, etc.â€
So, currently, I open Project first in order to be online and then run my
macro. But it’s annoying when using Excel to be forced to run Project
first.
So what can I do?
Daniel


__________ Information from ESET Smart Security, version of virus
signature database 5030 (20100415) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5030 (20100415) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Daniel]

Thanks a lot Rod. Actually I own your book so I’ll check the page.

 

[Rod Gill]

Another scholar, gentleman and judge of good whiskey! Happy programming!

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Thanks a lot Rod. Actually I own your book so I’ll check the page.



__________ Information from ESET Smart Security, version of virus
signature database 5032 (20100415) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5032 (20100415) __________

The message was checked by ESET Smart Security.

http://www.eset.com