How to rename an excel file with sysdate

[Trisha]

Hello,

I Have clicked on save as option to save a file, while doing that I need to rename a file appending with sysdate. I have searched in google find the below one line of code:

FileMove("C:\somefile.txt", "C:\somefile1.txt"), When I am trying to append with sysdate. It is not happening. Please help me out  with the small issue.

[Andreik]

FileMove("C:\somefile.txt","C:\somefile" & @MDAY & "_" & @MON & " " & @YEAR & ".txt")

Is this what you expect?

[Trisha]

Yes exactly. thank you Andreik :-)