C
Cousi75
In Project 2007, in a VBA macro, using Fileopen, how can I select the
database (Drafts database vs Published database) ?
database (Drafts database vs Published database) ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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
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
C
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 ?
R
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
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
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 ?
C
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