T
Troy Lee
I asked Rob this question yesterday on the project forum.
"I want to run a to do list report. I recorded the macro to run this
and the returning code was meager- one line only(ReportPrintPreview
Name:="To Do List"). What I want to do is get at the formatting
options offered in the report dialog box. I want to define all the
Definition fields, including the table and filter. How do I get at
these options? Is it easier to apply the table and filter before I run
the report?"
He replied with:
"I haven't tried this before, but if Project only recorded the print
preview,
then VBA doesn't support editing reports. I also searched the Object
Browser
and couldn't find anything there either.
You can create the reports manually, then use the Organizer to install
them
to different PCs. It is probably more reliable to create a new report
in the
custom report section and make sure it does not show in the menu so
when you
call and view the report it is less likely to have been changed.
Again, when
you install the macro, copy the report with the Organizer as well. "
In thinking about this further, can't I loop through the schedule and
capture all tasks associated with a resource? I can also pull whatever
stats from the task that I want for the output. Finally, I can then
send all this to an Excel spreadsheet, which is actually preferable
because I could use that sheet to collect actuals at the end of the
week.
Does this sound like a sound approach or are there roadblocks that I
am not seeing?
Thanks in advance.
Troy Lee
"I want to run a to do list report. I recorded the macro to run this
and the returning code was meager- one line only(ReportPrintPreview
Name:="To Do List"). What I want to do is get at the formatting
options offered in the report dialog box. I want to define all the
Definition fields, including the table and filter. How do I get at
these options? Is it easier to apply the table and filter before I run
the report?"
He replied with:
"I haven't tried this before, but if Project only recorded the print
preview,
then VBA doesn't support editing reports. I also searched the Object
Browser
and couldn't find anything there either.
You can create the reports manually, then use the Organizer to install
them
to different PCs. It is probably more reliable to create a new report
in the
custom report section and make sure it does not show in the menu so
when you
call and view the report it is less likely to have been changed.
Again, when
you install the macro, copy the report with the Organizer as well. "
In thinking about this further, can't I loop through the schedule and
capture all tasks associated with a resource? I can also pull whatever
stats from the task that I want for the output. Finally, I can then
send all this to an Excel spreadsheet, which is actually preferable
because I could use that sheet to collect actuals at the end of the
week.
Does this sound like a sound approach or are there roadblocks that I
am not seeing?
Thanks in advance.
Troy Lee