I have a command button in my excel file after clicking on which it
does some calculations.

I need a small piece of code at the end of my code which will save a
copy of that file (Save As) in C:\ with the current date and time (eg.
xxx06271315.xls) 0627 is the date 27th June and 1315 is the time 1:15
PM

Can anybody help?