Task Usage Extraction

C

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
 
C

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
 
R

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




Jan De Messemaeker said:
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
 
B

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
 
C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top