Hello, I have a 07 word document that I have a date in a table that I want to change to the next following Sunday when I click the button Named (PrintWeek). So lets use next week for instance, I enter 10/2/16 into this tables cell and click the button and it prints the document and changes the date to 10/9/16. How can I do this?



The cell is F:1

Thanks,

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]

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,

The download contains a Word document, not a third party add-on and you can download it without registering from the second link.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

In the word documents im sure its the DatCal.zip im needing but not sure what to incorporate into the document to accomplish what im after

Post #2 tells you which field to use. The Introduction, also referred to in Post #2, tells you how...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

macropod, I understand your trying to get me to do this on my own but for peat sakes I'm lost this is nothing like excel or access. Im just going to hang up the towel I have been searching for days and word just isn't the thing to be adding buttons and VBA I guess. I just was trying to make it easier on myself printing wise. Thanks....

Did you read the Introduction? If you had, and if you toggled Word's field shading on as it suggests, you'd have known by now that the 'Saturday, 12 December 2009' date in your post is a field that you can simply copy & paste from the tutorial into your document. Unless you need to adjust the field code for internationalization issues (as also discussed in the Introduction), all you need do is update the field. Indeed, if you have Word configured to 'update fields before printing', you don't even need to do that!

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]