I wanted to name a spread sheet that i generate using SQL in a specified Format.

The Name format should be like abcdef (week Start Date- to week End Date )_Count (Number of rows in the excel)

for example it should be as shown FullName 01.16.12 to 01.22.12_count 12345

where 12345 is the number of rows in my excel sheet

Can this be done? Thanks for the help in advance