Thread: Saving files
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kathy[_6_] Kathy[_6_] is offline
external usenet poster
 
Posts: 13
Default Saving files

I want to create a file so that when the user saves it
(with in a macro) it sequentally names the file

first save File1.xls, then file2.xls, file3.xls

The #'s 1, 2,3 are part of the worksheet, but I do not
know who to get that # to be part of the file name with
asking the user to do a file saveas file#

please advise
thanks