Exporting assignment information to Excel

[David L.]

How can I export time-phased assignment information to Excel? I am trying to
get as much information as possible out of the resource usage (I am using a
shared resource pool approach between different projects) view but it seems
to be limited. Does anyone know of existing VBA code that enhances the
assignment analysis?

 

[calihdog]

On the analysis toolbar there is a button labeled "Export Timephased Data in
Excel...". If you use this while you're in the resource usage view you will
be able to export timephased data to Excel. You are able to choose which
fields to export.

HTH.

 

[David L.]

calihdog,

Thanks for your help. Unfortunately the export only provides resource
information but not the assignment information (i.e. the tasks to which the
resources are assigned). How can I get this info too?

David L.

 

[robodob]

David, i too have been trying to find out how to get the resources and
assignments and hour breakdowns on one concise sheet. Usage reports will do
this for you but only in print form. WE NEED IT IN EXCEL> I will let you know
if I find anything out.

 

[David L.]

Robodob,

I eventually found out how to do this but I had to develop a macro to
extract the assignment information and get the data that I wanted. There was
no pre-canned query or export function that met my needs. I have another
macro that takes this data and dumps it into an Excel spreadsheet for further
processing. Let me know if you would like a copy of the code I wrote to do
this.

David.

 

[robodob]

Would very much like the macro. Also a screen shot of the exel form that
results from the macro.

I have configured msp (I am a const. co) to track construction activities,
do payroll, change orders, unit prices, projections, budgets, billing,
analysis, (using indicators) etc.

This is the one thing I truly need. If you are interested in my template,
let me know. I can share it with you.

 

[jlg]

David, I too am doing something very similar and it could save me a lot
of time if you would share these macros. My e-mail is
082401ATroundysDOTcom.

Thank you!

Judy

 

[ReKa]

Hi,

David, I too am doing something very similar and have tried to figure
it out for quite a while without any success. I would appreciate you
macro too.

My e-mail is: (e-mail address removed)

 

[Cheryl]

David,
I also have this need. Can you forward the macro to me as well? My email
is (e-mail address removed)
Thanks in Advance.
Cheryl

 

[RCR]

I would also like a copy of the macro!!! It would be very useful.


(e-mail address removed)




RCR

 

[Mvisscher]

Please send this makro to (e-mail address removed).

Thanks a lot

jolanda

 

[schroetp]

I have been trying to develop a similar macro, but have been unable to get it
to work. If you would be willing to share yours, it would be much
appreciated.

Email is (e-mail address removed)

THanks!

 

[DanSmoach]

This macro seems very interesting. could you please send a copy to
(e-mail address removed) or post the code.

Thanks

Dan

 

[DallasLDY]

Like everyone else, I've been working on the same thing. Please forward a
copy of the macro to:

(e-mail address removed)

I would really appreciate it.

Leslie

 

[Mike Oberneder]

David,
I would also like a copy of your code, if you don't mind. Would you mind
sending me a copy at (e-mail address removed)

Thanks in advance.
Mike

 

[DallasLDY]

I received a response from one of the other people who posted here in July
and asked for this information (thank you Dan - my only response).

It seems that this information is not being forwarded to anyone who has
asked. It seems that this problem has been solved in the 2007 version. If
your company is not going to upgrade to 2007, then you will have to do like
me and copy/paste the information. ugh.

Yet another disappointment.

 

[tonyhomer]

David,

Can you please forward a copy of the code, I have spent a number of
hours trying to do the same.

Regards.

Tony.

(e-mail address removed)

 

[ChuckF]

Robodob,

I eventually found out how to do this but I had to develop a macro to
extract the assignment information and get the data that I wanted. There was
no pre-canned query or export function that met my needs. I have another
macro that takes this data and dumps it into an Excel spreadsheet for further
processing. Let me know if you would like a copy of the code I wrote to do
this.

David.

 

[JulieS]

Hello Chuck,

Do you have a question?

Julie

 

[Ann]

The Analysis Wizard has been replaced in MS Project 2007 with PivotTable
reports. Does anyone know how to get timephased data into Excel Pivot Tables?

Thanks

Ann