time in subject line
 

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 = ")

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

time in subject line
 

If you want the time included in the filename, the easy way is to just leave
the colon out of the format:-

fname = Format(Range("E3").Value, "yyyy-mm-dd hhmm")

It will just show as 24hour (military time)


--
Regards,

OssieMac


"jatman" wrote:

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 = ")

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