Excel to MS Project Macro using Unique ID as reference

[glessed]

Want to update start date, finish date and % Work Complete fields in Excel and then update the corresponding fields in Microsoft Project 2000. Excel worksheet does have the MS Project "Unique ID" references for each row. Am very new to writing macros.

Any help in writng the Visual Basic Code would be appreciated.

 

[VBAjedi]

Not sure what you are asking. Excel doesn't have "fields" per se. . . it does have cells, and it also has various controls like textboxes and listboxes.

There are a number of ways of putting a value in a cell, but one simple one is:

Worksheets("MySheetName").Range("A5").Value = "WhateverValue"

I haven't worked with automating MS Project with VBA, so I can't help you on that part. . .


VBAjedi

 

[glessed]

Thanks for your response! I am trying to use the "Unique ID" as a primary key to make sure that I am entering data into the right cells in Microsoft Project. In my mind it is similair to performing the VLOOKUP function in Excel between worksheets.

Is there a VBA approach that allows you to use a reference field (Key number)in Excel, copy data from an adjacent cell and then find the same reference field (Same key number)in another application and paste the copied data (from Excel) to a cell adjacent to the referenced cell? I would assume that VBA code that performs this between Excel and another application, like Word, should be able to assist me in the right direction.

 

[AppStaff]

I would be interested in knowing this also. I do know that you can do what your asking via Import. i would assume automating this would involve an import method. you might even be able to run this from excel via automation.