To save your file in VBA with today’s date as part of the name, there are basically two functions that you need to know: Date and Format.
ThisWorkbook.SaveAs "C:My DocumentsMyFile" & Format(Date, "yyyymmdd") & ".xls"
The resulting filename, if you save it today, will be MyFile20040421.xls.
The Date function returns the current system date. The Format function converts the date to whatever format you want using y’s, m’s and d’s.