Almost there need a bit of help

[RFiginsky]

I am currently working on a macros that will take the percent complete from
an excel sheet and copy it to my project file. Currently I have it to do a
VLOOKUP on column A in excel with the Task Name in Project. if those are okay
it will copy the percent over to project. That was easy enough to write. The
problem I am having is I need it to look at and compare 2 columns in excel
and validate them with Task name and Text6 column in Project before it will
copy the percent complete from the excel sheet to Project.

Thanks for any help anyone can give on this. I can supply the code I have
now if it would be helpful.

 

[RFiginsky]

I think this might help with what I am trygin to do.

a = column A in excel
b = column B in excel
c = percent complete in excel

d = task name in Project
e = text6 in Project
f = Percent Complete in Project

so now

if "a" and "b" in excel are equal to "d" and "e" in Project

then copy "c" in excel to "f" in project

seems easy right. I hope someone can help.

 

[Mike Glen]

Hi RFiginsky,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[RFiginsky]

thanks Mike I will do that..also thanks for the link looks liek soem great
info on there for soem other ideas I have.

Rgs,
Bob

 

[Jim Aksel]

Additional help available from the Developer forum.
Something to consider -- use the UniqueID field from project rather than a
combination of Name and Text6 to uniquely identify a row in both files. The
UniqueID variable guarantees a row match unless the task has been deleted and
reinserted.

Using name and Text6 begs for problems... suppose someone accidentally adds
a space on the end of the Name of a task....
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[RFiginsky]

I never thought of using the UniqueID field. I have always used the text6
column and jsut started working on automating portions of my job. ( I am
tired of being up till 2 or 3 am just pulling results in to my master sheet )
Thanks for the suggestion, very much appreiciated.

Bob