I am very new to VBA.  I need to get actual work data from an excel
spreadsheet into the proper(by day, resource, subtask) Actual work field in
MS P 98.

So far, my macro goes out and gets the EXcel spreadsheet that has been
dumped by the accounting system.  It then loops through the Tasks and
Assignments in MS P, but it does not compare the A.Resource and the Excel
"Name" column or the A.TaskName and the Excel "Subtask" column in order to
then go get the date worked and the sum of hours from the spreadsheet and
place it into MS P.

The macro makes the Excel spreadsheet visible.  Do I need to place the
spreadsheet values into an array(?) and pass them into the procedure in
order to get the values?

Do I need to write this macro from the Excel side?

Thanks,
Carole

 Hello,
 The macro makes the Excel spreadsheet visible.  Do I need to place the
 spreadsheet values into an array(?) and pass them into the procedure in
 order to get the values?

* Not at all. You can read the Excel data as Cells (Row, Column).Value and
assign them to the appropriate    TimeScaleValue(X) as you seem to suggest

 Do I need to write this macro from the Excel side?

* Entirely your choice. If we are dealing with small volumes, itreally is
irrelevant; if you are dealing with large volumes, I would advise to aim at
the smallest number of Active X calls e. g. ik you have  many more Excel
instructions write in Excel and vice versa, this can speed up processing.