Sequencial file names
 

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.

Sequencial file names
 

Add a timestamp to it

format(now,"yyyymmddhhmmsss")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Neville" wrote in message
...
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.