Link to home
Start Free TrialLog in
Avatar of Europa MacDonald
Europa MacDonaldFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Sequential diary dates MS word

Could anyone give me simple instructions please ?

I want to print off a diary, a day to two pages, with sequential dates from todays date in the top corner.

Can I do this in MS word and if so how ?

thankyou
ASKER CERTIFIED SOLUTION
Avatar of Paul Sauvé
Paul Sauvé
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You would almost certainly need to use VBA to calculate the dates, so it is advisable that you are comfortable with VBA macros.
Here is a simple macro to do the job. You need to have a new blank document open and selected.
Sub MakeDiary()
    Dim d As Integer
    Dim dt As Date
    Dim strDate As String
    
    For d = 0 To 6
        dt = DateAdd("d", Now, d)
        strDate = Format(dt, "dd/MM/yyyy")
        ActiveDocument.Bookmarks("\EndOfDoc").Range.Text = strDate & vbCr & Chr(12) & strDate & vbCr & Chr(12)
    Next d
End Sub

Open in new window


If you aren't familiar with the VBA environment, there are basic instructions after the last block of code in this article:
https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/A_7236-Macro-code-to-convert-text-to-fields-in-Microsoft-Word.html

There is a more detailed article here:
http://msdn.microsoft.com/en-us/library/office/ff604039%28v=office.14%29.aspx
Hey Paul,
I'm surprised to see that I had the (then unanswered) question open for more than an hour while compiling my comment. I will look at your link with interest.
Hi Graham - quite often, it's the other way around! Have a good day!
MichaelGlancy,

I notice that you have posted a similar question for Excel.

Do you need any further help to do this in Word?