Task Usage Extraction

[clv]

Does Microsoft provide or does someone know of a utility that would allow the
extraction of timephased data from the task usage view? Would like the
output to look exactly like the task usage view in project. I am using
project standard 2003.

Thanks for your help,

clb

 

[Jan De Messemaeker]

Hi,

There are probably several ways, but I do what I know best and that is to
use the Timescaledata method in VBA.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[clv]

Was hoping that MS had provided or someone had already created the unil since
I am not a programmer and have no idea how to get this data out except by
copy and paste. This method leads to labor intensive data formatting to get
the outlining and hours into usable format. Need this for proposals.

Anyone else have any ideas??

clb

 

[Rod Gill]

Hi,

Microsoft's MSDN site has the timephased module from my book at:
http://msdn.microsoft.com/en-us/library/ee355231.aspx

--

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

Hi,

There are probably several ways, but I do what I know best and that is to
use the Timescaledata method in VBA.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf




__________ Information from ESET Smart Security, version of virus
signature database 4989 (20100331) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4989 (20100331) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[BlueAngel]

Rod,

Thanks for the pointer but as I indicated earlier I am not a programmer and
do not have the capabilities to create the utility/macro. Basically if I can
key it I can automate it.

I have searched and found that I am not the only one (I have seen many many
requests for this) who has requested this information. The current process I
use is to save the file as a web page (this gives me the indentation
required), use the task list with embedded assignment rows map, then copy and
paste the time phased month grid and do labor intensive clean up. This
format is required as is the ability to pull custom text fields as we use
these to map from our schedule to the customer IMS. I need to pull
information from the project start date to the end of work. If I could get a
utility that provided the html output in hte task list with embedded
assignment rows and the monthly timephased grid would same much time.

Hopefully someone can give some insight on how to automate this process.

clb

 

[Jan De Messemaeker]

Hi,

Create the macro? In the page Rod gives you the whole code is there!

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availabliy check:
http://users.online.be/prom-ade/Calendar.pdf

 

[C]

I finally figured out that I can just use the clipboard function via VBA. It
is as simple as that. I fortunately am using MSP 2003 and created a MACRO to
save the fields I needed to html. I then used the edit copy to get the
TimeScaled grid over to Excel. I ran this on a couple of files and figured
out that the html templates will pull different data depending on the
characteristics of the .mpp file. Once I figured this out I modified one of
the templates to just pull the data and no headers or other file info.
Then I created a Macro in Excel (Thanks to the VBA Gurus in the Excel
Discussions group) to do the pasting, formatting and cleanup in excel. The
drawback is it is a two part process and the use of the clipboard requires
discipline in that you don't let your self get interrupted. But it works
great.