![]() |
#3
|
|||
|
|||
![]()
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, |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Eduardo Care | Word | 1 | 08-13-2015 06:01 PM |
Calculation Button in Word tables | Barry Bolton | Word Tables | 3 | 02-14-2014 06:01 PM |
![]() |
Victora | Word VBA | 1 | 12-29-2012 08:47 AM |
![]() |
ndjustin20 | Word VBA | 1 | 02-08-2012 02:50 PM |
MS Word form - email button | floydwood | Word VBA | 0 | 05-10-2009 04:11 PM |