[Solved] Using VBA to save a file in excel 2010 with a different name each time [closed]

by


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]