Which database and table(s) should I hit for this type of custom
report using VBA?
Thanks,
Andy Novak
UNT
Andy,
Well, when you write VBA code the "database" you access is Project's
main database (i.e. Project's objects and properties). There is no
"table" that is accessed. You are probably thinking in terms of using an
SQL query, but that's not VBA.
Assuming you really do want to use VBA, here are some general steps.
First of all, the Notes field is not timescaled so there is no way to
access the added notes by week. You'll have to parse the notes text to
pull out that information, assuming the user adds notes text that
includes a time stamp. Second, you need read the notes property of each
assignment for each resource object. Use that to create whatever
"report" you need.
John
Project MVP
