Dec 22, 2004 #1 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
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
Dec 22, 2004 #2 Homersim2600 Technical User Dec 15, 2004 253 US 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 Upvote 0 Downvote
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
Dec 23, 2004 Thread starter #3 mustang98 Technical User Dec 7, 2004 12 US GREAT. Thanks. Upvote 0 Downvote