View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lisa Alex Lisa Alex is offline
external usenet poster
 
Posts: 1
Default Create sequential file name for uploaded template

I have an Excel template that I would like to put on our intranet. I want it
to create a unique, sequential file name each time it is uploaded, as well as
put that unique number in a cell within the template. For example, I want the
numbering to start with 1001. When someone uploads the file, the file name
will be 1001.xls and the document number cell will be 1001. The next person
that uploads the file will be 1002.xls.