Time PHased Export

[C]

I have the VBA book that Rod has published. What I need to do now is the %
allocation for each resource. Can someone tell me which pieces of VBA to
change to get this running.

Thanks in advance,

BlueAngel

 

[C]

I only need to know what to divide the allocation field by.

 

[C]

Got it all fixed and exporting what I need.

I only need to know what to divide the allocation field by.

 

[Rod Gill]

Glad we were of help!!

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

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

Got it all fixed and exporting what I need.



__________ Information from ESET Smart Security, version of virus
signature database 4933 (20100310) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4933 (20100310) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[C]

One other question Rod, What part of the code would have to be changed to
pull all the TSD for the project. Used the Project start and end dates
instead of the system start date and the loop for 12 months. I know I have
read that somewhere, but can't seem to find it.

BlueAngel

 

[Rod Gill]

Hi,

Don't loop for 12 months. Use:

Dim tsvs as TimescaleValues
Dm tsv as TimescaleValue

Set tsvs=Task.Timescaledata()
for each tsv in tsvs

next tsv

http://msdn.microsoft.com/en-us/library/ee355231.aspx is a link to a sample
module from my book on working with Timephased data: Microsoft liked it so
much they put it on MSDN!
--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

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

One other question Rod, What part of the code would have to be changed to
pull all the TSD for the project. Used the Project start and end dates
instead of the system start date and the loop for 12 months. I know I
have
read that somewhere, but can't seem to find it.

BlueAngel



__________ Information from ESET Smart Security, version of virus
signature database 4937 (20100311) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4937 (20100311) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[C]

Thanks Rod. I will give this a try.

Hi,

Don't loop for 12 months. Use:

Dim tsvs as TimescaleValues
Dm tsv as TimescaleValue

Set tsvs=Task.Timescaledata()
for each tsv in tsvs

next tsv

http://msdn.microsoft.com/en-us/library/ee355231.aspx is a link to a sample
module from my book on working with Timephased data: Microsoft liked it so
much they put it on MSDN!
--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

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






__________ Information from ESET Smart Security, version of virus signature database 4937 (20100311) __________

The message was checked by ESET Smart Security.

http://www.eset.com



.