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"
 

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

VBA - exporting serial letters to single documents 0
Word macro that can call cells out of Excel for a find and replace 0
Automation of scanned file storage based on content 0
Pause Macro 1
Synchronization problems while moving folders to new email 1
Export a table to text file with file name depending on certain da 7
Read only error when trying to export table using Macro 1
Excel Data Transfer Issue (strange situation) 1

Top