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

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to transfer the data from userform to spreadsheet for specific dates 0
Read only error when trying to export table using Macro 1
Pause Macro 1
transfer spreadsheet-create a date 2
Transfer Spreadsheet not starting new Tab 1
Excel Excel due and overdue date colours 2
Export a table to text file with file name depending on certain da 12
changing Parameter in macro 1

Top