do you know of a method that will assist in naming a file name with the folloiwng convention:
mmddyy(any 1 character)

and if the filename is already exists, then it is safe to assume that it's another file for that day and teh filename shoudl be

mmddyy2

thanks for the tip on the csv.

the line that is making the 1st worksheet the active worksheet, is that correct?