[Solved] Using VBA to save a file in excel 2010 with a different name each time [closed]
I do this on a daily basis saving the file as the previous days date. I modified what I use for what you are wanting: dim name as string name = Cells(1,2).Value & Cells(2,2).Value ActiveWorkbook.SaveAs() Filename:=name 1 solved Using VBA to save a file in excel 2010 with a different name each time [closed]