Export to Excel in Multiple worksheet

[Kalpesh Shah]

i need to pick a predefined summary task from each project and export it to
Excel sheet in multiple worksheet having one project for e.g if i am having
10 different project i need to create 10 worksheet and export the summary
task info of each project to that specified worksheet.
please let me know if we have any work around to implement this
i tried to post it in EXCEL forum they said please post it in Project SErver
please reply me

Kalpesh

 

[Rod Gill]

Hi,

You will need to write a VBA macro to do this. otherwise you will need to
export to 10 separate workbooks then manually combine into one.

 

[Kalpesh Shah]

This i need to do it thru Project Server Custom devlopment
is that possible to build multiple worksheet creation in single workbook

 

[Rod Gill]

No. You need to write VBA code or code externally with any language to read
data from the project server database. Excel VBA would be a great solution.