How do I export a date&time in a macro-Transfer Spreadsheet name

A

aleon

="O:\Folder\Folder\FileName" & (Format(Now(),"yymmdd")) & ".xls"
I'm trying to transfer a spreadsheet but want to add the time to the date
because the spreadsheet may be run several times in a day, so I don't want it
overwritten. I've tried adding time by doing the (Format(Time())
expressions, but I get error messages.
 
S

Steve Schapel

Aleon,

You mean like this?...
="O:\Folder\Folder\FileName" & Format(Now(),"yymmddhhnn") & ".xls"
 
Top