Project 2007 FileOpen in Published database

[Cousi75]

In Project 2007, in a VBA macro, using Fileopen, how can I select the
database (Drafts database vs Published database) ?

 

[Rod Gill]

You can't. Projects can only be opened from the Drafts database. The
Published database only has data for use with the web based PWA. The Drafts
database is only for Project Professional data.

--

Rod Gill
Microsoft MVP for Project

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

 

[Cousi75]

You can't. Projects can only be opened from the Drafts database. The
Published database only has data for use with the web based PWA. The Drafts
database is only for Project Professional data.

--

Rod Gill
Microsoft MVP for Project

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






- Show quoted text -

Rod,

Thank you for your response.

In Project Professional, when I use the open file command, on the
window I can select which database I want to use (Working or
Published). You are sure there is no way to select the database from
VBA ?

 

[Rod Gill]

Try recording opening from both. If the code is the same for both, then no.

--

Rod Gill
Microsoft MVP for Project

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

You can't. Projects can only be opened from the Drafts database. The
Published database only has data for use with the web based PWA. The
Drafts
database is only for Project Professional data.

--

Rod Gill
Microsoft MVP for Project

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






- Show quoted text -

Rod,

Thank you for your response.

In Project Professional, when I use the open file command, on the
window I can select which database I want to use (Working or
Published). You are sure there is no way to select the database from
VBA ?

 

[Cousi75]

Try recording opening from both. If the code is the same for both, then no.

--

Rod Gill
Microsoft MVP for Project

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







Rod,

Thank you for your response.

In Project Professional, when I use the open file command, on the
window I can select which database I want to use (Working or
Published). You are sure there is no way to select the database from
VBA ?- Hide quoted text -

- Show quoted text -

Rod,

I recorded opening for both.

When I select Published Store, the recorded command is (FileOpenEx
Name:="<>\Test", ReadOnly:=True)
When I select Working Store, the recorded command is (FileOpenEx
Name:="<>\Test", ReadOnly:=False)

The Store is not specified in the command !

I'm going to have a look at "Project Server Interface" to connect to
the different databases