View Full Version : Need detailed task assignment export routine


G Lykos
09-14-2006, 05:22 AM
Greetings! Am looking for code to export detailed task assignments
(time-phased work per assigned resource per task) to Excel (or Access).

Thanks,
George

EPMdev
09-14-2006, 09:21 AM
I know two ways:
1. VBA and TimeScaleData() method

2.
a. go to: Tools | Options | Save [tab]
b. check "Expand timephased data in the database"
c. save project as access database



G Lykos wrote:
> Greetings! Am looking for code to export detailed task assignments
> (time-phased work per assigned resource per task) to Excel (or Access).
>
> Thanks,
> George

EPMdev
09-14-2006, 09:34 AM
You can also find useful that link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/pjsdk/html/pjsdkExtractingTimephasedData_HV01112435.asp

EPMdev wrote:
> I know two ways:
> 1. VBA and TimeScaleData() method
>
> 2.
> a. go to: Tools | Options | Save [tab]
> b. check "Expand timephased data in the database"
> c. save project as access database
>
>
>
> G Lykos wrote:
> > Greetings! Am looking for code to export detailed task assignments
> > (time-phased work per assigned resource per task) to Excel (or Access).
> >
> > Thanks,
> > George