Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Save a Word Doc by Date?

Status
Not open for further replies.

mustang98

Technical User
Dec 7, 2004
12
US
Does anyone know how to save a Word Doc in VBA based on the Date?
Such as: SaveAs "TitleofDoc" & Date
Date should look like: 122304

Thanks
 
ActiveDocument.SaveAs FileName:="textgoeshere.doc" & Format(Date, MMDDYY), FileFormat:= _
wdFormatDocument, LockComments:=False, Password:="", AddToRecentFiles:= _
True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:= _
False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
SaveAsAOCELetter:=False

You should check out "How to record macros" within the MSOffice help...

LF

"As far as the laws of mathematics refer to reality, they are not certain; as far as they are certain, they do not refer to reality."--Albert Einstein
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top