Macro to save XLSM in a define path with year day and month changed

Hello

I need to save a document in the following path: http://MyProjects/Shared%20Documents...014_01_29.xlsm

Only the year month and day sould change when I hit the save button/macro: 2014_01_29

Can you please help me to build a macro that would save my file as per my above explanation??

If I would run the macro today the excel file should be saved in the path:
http://MyProjects/Shared%20Documents...014_01_31.xlsm

many thanks,
Graig

I tried that but I don't have the part "http://MyProjects/Shared%20Documents/TFF/TFF_MM_" taken into account. I only get the date..

HTML Code: