J
jatman
good afternoon,
i have a macro that i want to adjust just a bit. the portion of the macro
is as follows:
fname = Format(Range("E3").Value, "yyyy-mm-dd") & " " & Range("A1").Value
ActiveWorkbook.SaveAs Filename:="C:\Users\Documents\" & fname & ".xlsx",
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
'Sub Email() - sends a copy of the email to the recipients listed in the
Recip Array
Recip = Array("(e-mail address removed)")
everything works fine, but in the subject line, i would like the time
displayed along with the date. i tried to save the file in the format
yyyy-mm-dd hh:mm but filenames do not allow ":" . next i tried to assigne a
secondary name subj = format (range("E3").value, "yyyy-mm-dd hh:mm") and i
added that just below the recip = array... in the macro, but that does not
show the time either.
any other suggestions?
jat
i have a macro that i want to adjust just a bit. the portion of the macro
is as follows:
fname = Format(Range("E3").Value, "yyyy-mm-dd") & " " & Range("A1").Value
ActiveWorkbook.SaveAs Filename:="C:\Users\Documents\" & fname & ".xlsx",
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
'Sub Email() - sends a copy of the email to the recipients listed in the
Recip Array
Recip = Array("(e-mail address removed)")
everything works fine, but in the subject line, i would like the time
displayed along with the date. i tried to save the file in the format
yyyy-mm-dd hh:mm but filenames do not allow ":" . next i tried to assigne a
secondary name subj = format (range("E3").value, "yyyy-mm-dd hh:mm") and i
added that just below the recip = array... in the macro, but that does not
show the time either.
any other suggestions?
jat