![]() |
|
|
|
#1
|
||||
|
||||
|
If it's always the next following Sunday from whatever 'today' is, you don't need a macro. To see how to do this and just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at: http://windowssecrets.com/forums/sho...ation-Tutorial or: http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled Calculate a Stepped Date - for which the field is already configured to calculate 'next' Sunday. Do read the document's introductory material.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
#2
|
|||
|
|||
|
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 Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Automatize word button.
|
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 |
Timestamp Button Word
|
Victora | Word VBA | 1 | 12-29-2012 08:47 AM |
Clickable button in word
|
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 |