Project 2002, Copying time phased data to excel

[Desmond]

hell
THIS MESSAGE IS RESENT BECAUSE I AM NOT CERTAIN THE FIRST ONE WENT THROUGH. IF IT DID, PLEASE EXCUSE ME

I have a problem linking timephased resource data from Project 2002 to Excel. I have followed some of the messages on the newsgroup, but I need further guidance

The "Analyse Time scaled data in Excel" tool does not work for transferring material quantities. I can copy and paste the data, but this is not acceptable, prone to error. It does not appear possible to link the timephased data to Excel, as you can with the data tables

It seems that I need a customized macro that will select the data from the materials usage time phased sheet, open an Excel file, and paste the data line by line so that I can allocate the data using another macro

I trust you will be able to assist .

Incidentally, I went to Jack Dahlgren home page, which I got from this group, and tried to contact him, but the email address on his home page does not respond. Can you provide a correct contac


Desmond Mallalieu

 

[Rod Gill]

Hi,

There is a timephased macro example on the www.mvps.org/project/ site. Try
editing that to get what you want.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

hello
THIS MESSAGE IS RESENT BECAUSE I AM NOT CERTAIN THE FIRST ONE WENT

THROUGH. IF IT DID, PLEASE EXCUSE ME.

I have a problem linking timephased resource data from Project 2002 to

Excel. I have followed some of the messages on the newsgroup, but I need
further guidance,

The "Analyse Time scaled data in Excel" tool does not work for

transferring material quantities. I can copy and paste the data, but this is
not acceptable, prone to error. It does not appear possible to link the
timephased data to Excel, as you can with the data tables.

It seems that I need a customized macro that will select the data from the

materials usage time phased sheet, open an Excel file, and paste the data
line by line so that I can allocate the data using another macro.

I trust you will be able to assist .

Incidentally, I went to Jack Dahlgren home page, which I got from this

group, and tried to contact him, but the email address on his home page does
not respond. Can you provide a correct contact