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

by

[ad_1]

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

[ad_2]

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