View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
npereira[_5_] npereira[_5_] is offline
external usenet poster
 
Posts: 1
Default Saving as a specifc file name in increments


Hi all,

I have an invoice worksheet that I keep adding stuff to to make it wor
as simply as possible. I have a Text box in the invoice sheet that
enter manualy a invoice #. Then I save the file with the name as th
invoice number, ex: 00040.xls

Now, I would like to not have to manualy put the invoice number in th
invoice and save it as that name.

Is there a way that when save-as my invoice.xls, that it looks in th
same directory and saves itself as the next invoice # (file 0040.xl
exist? then save as 0041.xls).

Let me know if this is remotely possible.

Regards,

Nelso

--
npereir
-----------------------------------------------------------------------
npereira's Profile: http://www.excelforum.com/member.php...fo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=27000