How to read Timesheet data in VBA?

[asadim]

How can I read the number of hours entered for a certain task on a certain
date in a specific timesheet? I'd like to do it in VBA.

Any help is greatly appreciated.

 

[Rod Gill]

You mention a specific timesheet. Does this mean you are wanting to read
from Project Server data? If so, the version number is most useful in any
question!

For 2003 query the MSP_VIEW and MSP_WEB tables in SQL Server. In Project
2007 query the reporting database. Look in the default Views for the
information you want.

Simplest is to use oledb in VBA to read data from SQL Server. Search
msdn.microsoft.com for example code.

--

Rod Gill
Project MVP

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