Sequencial file names

N

Neville

I am developing an Excel model, driven mainly by macros, to allow data
capturers to punch in basic financial data, which will then be automatically
emailed to a particular destination. The problem I am experiencing is how to
get my model to automatically name each file uniquely and sequentially before
it gets emailed.
 
B

Bob Phillips

Add a timestamp to it

format(now,"yyyymmddhhmmsss")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top