I've never used MS Project and I have no idea what kind of data this is.
But I'd guess that you have to get it into an external form by copying it to
the Clipboard or saving it to a file, from which Excel can read it.

--
Jim Rech
Excel MVP
"Sarah" wrote in message
om...
| All,
|
| I have a timescale array in MS Project that looks like this:
| Set TSV = ActiveCell.Resource.TimeScaleData(txtFromDt.Value,
| txtToDt.Value, _
| pjResourceTimescaledWorkAvailability, pjTimescaleDays)
|
| I need to get this information into a table in Excel, and I don't
| really understand much about arrays. I need the Resources listed down
| the side (the rows), the date range listed across the top (the
| columns), and the TimescaledWorkAvailability in the appropriate
| intersecting cells. If anybody knows how to do this, I would
| appreciate the help.
|
| Thanks!
| Sarah
|