Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-26-2016, 07:10 PM
macropod's Avatar
macropod macropod is offline Add VBA to a button in Word Windows 7 64bit Add VBA to a button in Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


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]
Reply With Quote
  #2  
Old 09-26-2016, 09:35 PM
oxicottin oxicottin is offline Add VBA to a button in Word Windows 7 32bit Add VBA to a button in Word Office 2007
Novice
Add VBA to a button in Word
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add VBA to a button in Word 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
Add VBA to a button in Word Timestamp Button Word Victora Word VBA 1 12-29-2012 08:47 AM
Add VBA to a button in Word 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft