save sheet and name it acording to the specific date

[laric]

Hi,

I have this simple code:

[B

Please Login or Register  to view this content.

Now I want to add a date after Report so the name today for the report will be Report_10/10-2012

So my question: If I have a TODAY() code in cell A1 can I make the last part of "ActiveWorkbook.SaveAs Filename:="S:\WORK\rapporter\Report" refer to this cell?

[thisisgerald]

Hi laric,

maybe this one?

Please Login or Register  to view this content.

[laric]

It works, thank you very much thisisgerald

[thisisgerald]

Your welcome!

Thanks for the rep.