Comparing external dates

[iron]

I have an excel file which comes from an Oracle DB and I want to compare
activities & dates in this file with those in my MSP2000 file. For those
activities that have differing dates (start & finish), I want to format the
MSP bars differently. Is there an easy way to do this?

I have done something similar comparing 2 Excel files using VLOOKUP, but not
between Excel & MSP.

 

[Rod Gill]

In Project you will need to loop thru all Tasks and link to Excel (search
help on working with other applications. You will then need to find the same
task in Excel and compare. I suggest you set the Baseline (or Baseline 10
etc.) date for the Task to be the same as Excel. The Tracking Gantt chart
will then show the difference.

 

[iron]

Rod,
I am familiar with tracking gantts, but my question is more about how to
perform the comparison from project. Once that is done, I'll copy/paste to
baseline10 the differences. Is there something similat to lookup in MSP/VB?

 

[Rod Gill]

No,

You need to use a VBA macro to automate Excel and read in the data. The only
other alternative is to have the Excel data in the form of a Project
workbook then import to Project and use the project compare utility.

 

[iron]

Thanks, I'll experiment with both...macros in Project is new territory for me.