Microsoft Office Forums - View Single Post - save a file with a predetermined date in VBA

Thread: save a file with a predetermined date in VBA

View Single Post

Old

03-23-2014, 07:47 PM

macropod

macropod is offline

macropod uses Windows 7 32bit

Windows 7 32bit macropod uses Office 2010 32bit

macropod uses Office 2010 32bit

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

Default

Try something based on:

Code:

Sub Demo()
Dim StrDate As String
StrDate = Format(Int(Date / 7 + 1) * 7, "YYYY MM DD")
MsgBox StrDate
End Sub

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

Reply With Quote