Change the excel file name based on system date as suffix

[paradise]

Hi,

How can I change the file name of my excelfile based on system date of computer.The prefix to system date would be in text(string).

With Rgds,
Suresh

 

[chirayu]

If you mean when saving the file, you want to save filename with current date then it variable be something like below & use the variable with the SaveAs code to name your file

Dim MyFile As String

MyFile = "Test " & Format(Date, "DD/MM/YYYY")

 

[paradise]

My file name say for e.g is 'Test' which is in certain folder.

Is above is the complete code.If it is complete code then perhaps there is an error.

 

[chirayu]

The above only defines your variable. You will need to use the variable along with the code for SaveAs macro (links below)

http://www.rondebruin.nl/win/s5/win001.htm
https://msdn.microsoft.com/en-us/library/office/ff841185.aspx