Margarita Hiett said:Hello,
Is it possible to get a list of all the Enterprise resources, not just
the once associated with a particular project, using VBA?
Thanks in advance,
Margarita
__________ Information from ESET Smart Security, version of virus
signature database 4534 (20091022) __________
The message was checked by ESET Smart Security.
http://www.eset.com
Hi,
I would use OLEDB to read the Resources from Project Server's Reporting
database. That is the easiest way.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:http://www.projectvbabook.com
__________ Information from ESET Smart Security, version of virus signature database 4534 (20091022) __________
The message was checked by ESET Smart Security.
http://www.eset.com
Margarita Hiett said:Rod,
Thanks so much. Can you point me to some examples?
__________ Information from ESET Smart Security, version of virus
signature database 4537 (20091023) __________
The message was checked by ESET Smart Security.
http://www.eset.com
No specific examples, but search for examples of reading from SQL Server
using OLEDB. The schema for the reporting db is in the Project SDK you can
download from MSDN.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:http://www.projectvbabook.com
__________ Information from ESET Smart Security, version of virus signature database 4537 (20091023) __________
The message was checked by ESET Smart Security.
http://www.eset.com
Margarita Hiett said:Hi Rod,
It seems that MS Project 2007 does not support OLEDB.
Is there another way of reading enterprise resources programmatically?
Thanks so much.
__________ Information from ESET Smart Security, version of virus
signature database 4537 (20091023) __________
The message was checked by ESET Smart Security.
http://www.eset.com
Margarita Hiett said:Hi Rod,
It seems that MS Project 2007 does not support OLEDB.
Is there another way of reading enterprise resources programmatically?
Thanks so much.
__________ Information from ESET Smart Security, version of virus
signature database 4537 (20091023) __________
The message was checked by ESET Smart Security.
http://www.eset.com
The View to look at is the dbo.MSP_EpmResource_UserView which also has all
custom fields in its last columns..
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:http://www.projectvbabook.com
__________ Information from ESET Smart Security, version of virus signature database 4537 (20091023) __________
The message was checked by ESET Smart Security.
http://www.eset.com
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.