¿How can I edit the name of a file I want to export to Excel?

[Orybos]

I need to save the same file each day, but each day I have to manualy edit the file´s name to the format : "[FileName]_DD\MM\AAAA_HH: MM:SS.xls"

Truth be told I´m done with it, I just whant to know how to create a Macro that saves the file with the systems date, or any other forms that saves me time each day.

Thanks in advance.

[NeoPa]

You should be able to save it as a different filename when you save it. What is the code you currently use to save the file?