View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rd rd is offline
external usenet poster
 
Posts: 6
Default saving an excel file with a serially increnmenting number

Hi,

Can you please direct me to code that allows me to save my excel files in a
serially incrementing default name, such as book201, book203, book204, etc.
as you are aware, excel always go back to book1 whenever you start a new
cession, and it doesn't know that the last book was, say book204, and that
therefore, it should suggest the next higher number, namely book205.

i hope my request is clear.

Thanks in advance.

RD