ActiveWorkbook.SaveAs FileName:=Workbooks(myFile & Format(Date, "mmddyy")

You can't add the date and us SaveChanges = False. It won't save anything.

"Rpettis31" wrote:

For the life of me I can not remember how to add a variable name to a file
path.
I have converted a file from text to xls and have saved it as myfile - date
in mmddyy

I have tried workbooks("myfile-"&date).close savechanges:=false.

but it does not like that.