Fill the "Resource Usage" View using VBA

D

DeeJay1981

Hi,
I was recommended to post this here again,
so this was my original post:

Hi,
I'm trying to fill the "Resource Usage" View with some data imported from
Excel or Clipboad.
To figure out how this works I recorded some macros and tried to understand
the vba code generated.

I understand what codelines like the following mean:

ActiveProject.Resources.UniqueID(1).Assignments.UniqueID(2097156).TimeScaleData(StartDate:="18.12.07 00:00", EndDate:="19.12.07
00:00", Type:=8, TimeScaleUnit:=4, Count:=1).Item(1).Value = "8"

But I have no idea how the "Assignments.UniqueID(2097156)" ist generated.
What ist the logic behind this 7-digit number? First I was thinking about a
time- or date-code..
Or is there any other possibility to fill this form, without knowing this
UniqueID 7-digit number?

THX in advance
cu Markus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill "Resource Usage" View using VBA 1
Resource Usage View Zeroing Work in a Date Range Macro 13
Fill "Task Usage" View using VBA 3
issue in resource usage view 2
problems accessing BaseLine Work thru VBA in Microsoft Project Server 0
Assignement Data Different on Task Usage from Resource Usage View 2
Fill "Task Usage" View using VBA 1
resource usage per shift 3

Top