Project updated automatically fed from Excel

[rsmith27]

Hi,
I have a progress report in excel 2003 which details key dates planne
& actual for 27 sites requiring a fire alarm upgrades. I have the
manually created this in project 2007 standard to give me a bette
indication of when specific tasks are required and what resource i
needed etc.

My query is can this be updated automatically, fed from the exce
progress sheet?? If so how?

Thanks for your help

 

[Jan De Messemaeker]

Hi,

It all depends which data... some analysis is necessary.
Normally this is done through VBA which can read both Excel and Project
data.
HTH

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