Link to Excel with VBA question

[troy_lee]

I know that linking to Excel is fragile because Project won't keep up
with a cell address change. I would like to "link" to Excel via VBA by
looking for a part number in an Excel sheet and then finding the part
number in Project. Once the part is found there are about 5 cells from
the Excel sheet that I would like to update Project fields (custom
fields) with.

Does anyone have code for something like this already? If not,
suggestions for a general approach is greatly appreciated.

Thanks in advance.

TL

 

[John]

I know that linking to Excel is fragile because Project won't keep up
with a cell address change. I would like to "link" to Excel via VBA by
looking for a part number in an Excel sheet and then finding the part
number in Project. Once the part is found there are about 5 cells from
the Excel sheet that I would like to update Project fields (custom
fields) with.

Does anyone have code for something like this already? If not,
suggestions for a general approach is greatly appreciated.

Thanks in advance.

TL

TL,
I seriously doubt anybody has code to do the specific comparison you're
looking for. However, fellow MVP, Rod Gill's has an excellent book on
Project VBA. In it are several examples of procedure interfacing Project
and Excel. For more information on Rod's book see,
http://www.projectvbabook.com

There have also been previous posts in this newsgroup with VBA code
snippets that set up the basics for what you need. I posted something
myself a few weeks back but I can't remember the date and I also don't
remember if it was response I wrote in this newsgroup or in our sister
newsgroup, microsoft.public.project. Try a search.

John
Project MVP

 

[John]

TL,
I seriously doubt anybody has code to do the specific comparison you're
looking for. However, fellow MVP, Rod Gill's has an excellent book on
Project VBA. In it are several examples of procedure interfacing Project
and Excel. For more information on Rod's book see,
http://www.projectvbabook.com

There have also been previous posts in this newsgroup with VBA code
snippets that set up the basics for what you need. I posted something
myself a few weeks back but I can't remember the date and I also don't
remember if it was response I wrote in this newsgroup or in our sister
newsgroup, microsoft.public.project. Try a search.

John
Project MVP

TL,
I found the post I referred to in my previous response. Take a look at
the posting in this newsgroup dated May 13,2009 with the subject line,
"Re: how to reference a range or series of cells in Excel"

John
Project MVP