Question for Rod Gill

T

Troy Lee

Rod,
I bought the VBA book. I love it. I have a question.

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?

Thanks for all of the help, both offline and online.

Troy Lee
 
R

Rod Gill

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.

Glad you enjoy the book!

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx
 

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

Top