Exporting Data to Excel

[Trivikram]

Hi.. Could anyone help in exporting the data from Resource Usage view of PS
07 wherein I can get resource wise / project wise / day wise actual manhours
logged in by the resource into an excel sheet.

Thanks,
Trivikram.

 

[Rod Gill]

You can use MSQuery in Excel to read from the reporting db. There are Views
in the reporting db that provide data by day so it's easy to report by any
time period you want.

--

Rod Gill
Microsoft MVP for Project

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

 

[Trivikram]

Hi... Gill, Thanks for the response.

Could you please elaborate the procedure for accomplishing this. Am not that
strong with VB.

Thanks,
Trivikram.

 

[Rod Gill]

MSQuery doesn't use VBA, it's all done via a user interface from Excel, Data
menu.

--

Rod Gill
Microsoft MVP for Project

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

 

[Trivikram]

Hi... Gill, Thanks for the clarification.

Could you please elaborate / appraise me of the steps or procedure for
accomplishing this.

Thanks,
Trivikram.