VBA for printing Gantt by week

W

Warren Rust

I did a quick search and didn't see this already covered.

I track upcoming planned events in a MSProject file to allow me to see them
in the Gantt format (as opposed to the Excel spreadsheet they come to me on).
These events are from one to many days duration and I find it convenient to
view them by week to check for conflicts. I can print them manually by
filtering by date range and setting the same print range in the Print dialog
box. However, I would really like a macro to do that for me as I print these
out for the upcoming year at the beginning of each month.

I've written the following vb script:

Sub PrintWeek()
' Macro PrintWeek
' Macro Recorded Tue 12/12/06 by Warren Rust.
For i = 1 To 52
FilterApply Name:="Date &Range..."
FilePrint ' FilePrint FromPage:=1, ToPage:=1, PageBreaks:=False,
Next i
End Sub

which steps me through the process and allows me to use keyboard only. But,
I would really like to know if it's possible to set this thing up to step
itself through the process on its own starting (Sunday through Saturday) at
the project start date and ending 52 weeks later.

any help would be appreciated (even if it's just expert advice to stop
banging my head against my monitor).

thanks,
- wr
 
M

Mike Glen

Hi Warren ,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP
 

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

VBA for printing Gantt by week 6
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
VBA correct syntax 5
HELP!! Gantt Chart Printing not Working 1
Word VBA Copy Heading and Content 4
VBA Coding Help for Beginner 0
Need Help with a VBA subroutine 0
VBA - exporting serial letters to single documents 0

Top