Insert date and time in Word

That is what I had to do.

The thing is that with the Long Date set at dddd, MMMM dd, yyyy in the Control Panel, with English (U.S.) selected in the Insert Date dialog, the result is dddd, MMMM dd, yyyy.  However if English (Aus) is selected in that dialog, the result is dddd, d MMMM yyyy.  Now one can anticipate the day coming before the month for Australian English, but where did the second d go to.  One would expect dddd, dd MMMM yyyy based on the Control Panel Long Date setting

What do you mean "... and named it DateDoneRight"?

It is already named DateLongStamp.

1.  Close down Word, then open Word

2. Open the VBE (Alt+F11)

3. Locate and select the project in the Project Explorer (Project pane).  The project  you select will be called "Project (Document 1).

4.  Expand that tree (click the little + sign on the left)

5.  Expand the Microsoft Word Object tree (click the little + sign on the left)

6. Dbl-Click "ThisDocument"
7. In the big empty code window on the right of the VBE, paste in:

Sub DateLongStamp()

 'Inserts current date

 Selection.InsertDateTime DateTimeFormat:="dddd, MMMM d, yyyy", InsertAsField:=False

End Sub

8.  Press the F8 key (three times to step through the code) or press F5 to run the code, or press "Run>Run Sub/Userform" on the VB Editor menu.

9.  Close the VBE and look at your document.

What is the result?

The "Project Explorer" is the "Project" pane in the VB Editor.

Press Alt+F11 to display the VB Editor.  If not displayed, display the Project Explorer pane by using the VB Editor "View" menu and select "Project Explorer."

It is is becoming clear to me that my instrutions for installing and employing a macro are not as clear or helpful as I had hoped they would be.  If you don't mind, and if you get it sorted out, please send me feedback as to what you think I should change to make it easier to understand.

 

• I locate and select the project in Project Explorer.
• Use the VBE "Insert" menu to insert a new standard module.
• Select the new module and use the Properties Window "Name" property to give my new module a meaningful name (e.g., I often name my modules modMain).
• Paste my procedure into the main code pane.

I then immediately step through the new procedure using F8 or run the procedure using the VBE toolbar or menu commands.

I did the above and named it DateDoneRight and then F8 and I get "Compile error invalid outside procedure"

The "Project Explorer" is the "Project" pane in the VB Editor.

Press Alt+F11 to display the VB Editor.  If not displayed, display the Project Explorer pane by using the VB Editor "View" menu and select "Project Explorer."

It is is becoming clear to me that my instrutions for installing and employing a macro are not as clear or helpful as I had hoped they would be.  If you don't mind, and if you get it sorted out, please send me feedback as to what you think I should change to make it easier to understand.

Greg, I got as far as: "Then copy UpdateAllFields procedure shown above and paste it in the VBE code pane below the Option Explicit statement (if present)."

But the top right hand corner doesn't read UpdateAllFields instead it says: (Declarations) and the drop down arrow brings Macro1 Macro2, Macro3, Macro4 and Macro5. One of them is probably my AutoCorrect Utility which I use. The newest is Macro5:

'Macro5 Macro

' DateLongStamp()

Now what?

I wonder if I just change the “MMMM d, yyyy”, False, to read “MMMM d, yyyy”, True? Would that do it?

It is highly unlikely that you will screw it up. The downside would be directly proportional to the degree of screw up as highly as unlikely as that is.

IMHO Word is like a Maserti.  Those who elect not to use macros keep it in first gear.

 

Greg,

Where do I find: "I locate and select the project in Project Explorer."

I went to Start menu and pasted Project Explorer but didn't see it.