Automatically saving a file with date & time as the file

[Treeny]

I have a macro looping continuously. After a certain point inthe macro a file is exported to Excel. I do not want the file to be overwritten every time the macro loops. How can I get Access to save this file with say a filename of today's date and time?

 

[bat17]

strSaveFilePath = "C:\MyDiectory\MyFile" & Format(Now(), "YYYYMMDDHHMM") & ".xls"
xlBook.SaveAs strSaveFilePath

where xlBook is the variable for your Excel book.

HTH

Peter