Macro to import data from Excel to MS Project 2003

[Chuck H.]

Hi everyone,

Has anyone out there did a macro that provide that feature? I guess yes, can
you display the macro so any one who may need it may use it.

Cheers!

Chuck

 

[Jack Dahlgren]

I have some examples of writing to excel from project, but by reversing a
line or two you could have it write to Project from excel.

Look here for examples:

http://zo-d.com/blog/archives/programming.html

and

http://masamiki.com/project/macros.htm

-Jack Dahlgren

 

[Chuck H.]

Thank you Jack for your prompt reply, I will give it a try.

Cheers,

Chuck

 

[Neffite]

Hi Chuck, were you successful at getting your Excell data into Project? Will
your code work for 2007? The problem I am running into is that Project 2007
does not recognize .xlsx or .xlsm.