View Single Post
 
Old 09-26-2016, 09:35 PM
oxicottin oxicottin is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Dec 2012
Posts: 5
oxicottin is on a distinguished road
Default

I'm on a work PC so I cant register to look at the .zip nor can I download any third party add-ons. I'm looking for some VBA that if I entered Sundays date (9/25/16) in cell F:1 and clicked the print button Named (PrintWeek), it would print the page and automatically change that date to the following Sunday which is 10/2/16 and I can print it again and it would change the date to the next Sunday and so on.

Something like:

Private Sub PrintWeek_Click()
'ActiveDocument.Range("F:1") Something Here to change date
ActiveDocument.PrintOut Range:=wdPrintCurrentPage
End Sub

Thanks,
Reply With Quote