>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

You could name the file: 'D' + dtos(date()) + '_T' + chrtran(time(), ':', '') + '.csv'

>thanks for the tip on the csv.
>
>the line that is making the 1st worksheet the active worksheet, is that correct?

No. Go back and look at the code I posted.

loActiveSheet = loBook.Sheets(1)