Macro to re-name a file to yesterday date in a specfic directory

Hi Mate,

Excel noob here.

I am trying that my macro to re-name a file which is on my desktop to yesterday's date i.e 'File 4-8-13'

Macro which i record doesn't record this action. How can i make this happen ?

Sub Macro1()
'
' Macro1 Macro
'

'
    ChDir "C:\Desktop\File.xlsx"

End Sub

I want macro to re-name this 'file.xlsx' to yesterdays date. i.e 'File 4-8-13.xlsx' - If possible - ta

Sorry for the trouble guys, thanks in advance