macro code help saving with date and time in sheet name

[markster]

Hi - I need some help with some code that I need to add to a wider back up macro that I created. Basically, I need my macro to save but also include the time of saving (I can get it to add the date automatically but can't figure out how to get it to add the time). Can anyone help?
M

 

[Lewiy]

Are you wanting the date and time to be saved in a cell somewhere? In which case:

Range("A1") = Date & " " & Time

Should do it.

 

[markster]

hi mate - the date and time won't actually be in the spreadsheet at all. I just need it to prefix the save name with it.
Cheers

 

[Lewiy]

How are you currently defining the save name?

 

[markster]

Hi mate as follows:

.SaveAs Filename:="C:\" & ws.Name & " " & Day(Now) & "-" & Month(Now) & "-" & Year(Now)
.Close

Cheers
M

 

[Lewiy]

.SaveAs Filename:="C:\" & ws.Name & " " & Date & Time

Should do the trick