"Output to" - file name to include date

[ipr1]

Hi - I would like to output a ".snp" file to another drive and since I will be send a new file each week, I would like to have the file name change by date: e.g. "data_031105.snp" and then "data_031805.snp" the next week etc.

I have search the forums and cannot find any solutions; however, I apologize in advance if this question has been asked before and I missed it. Thanks for your help and enjoy the weekend.

 

[ghudson]

For the file name parameter you would do something like this...

FileName = "data_" & Format(Date,"mmddyy") & ".snp"

Although I suggest you put the year first so that the files are easier to sort

FileName = "data_" & Format(Date(),"yyyymmdd") & ".snp"

 

[ipr1]

Thanks you for your response - I appreciate it.