Sequencial file names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Add a timestamp to it

format(now,"yyyymmddhhmmsss")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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

Import old dos sequencial data 3
Avoiding the worksheet specific name in a macro 2
Excel to ASCII Fixed Format 2
Using cell data as file name 1
HDI set cell content as the default file name for a new Excel wb 5
Excel 2007 General Question 6
Need help with an automated email sender 0
Copy or Move a spreadsheet 1

Back
Top