On my spreadsheet cell C2 displays a date in the (04/27/05) format. What I
need to do is have a macro which will save the document to C:\My
Documents\????\XXXXXX. Where ???? is the year in cell C2 and the XX-XX-XX is
the date (04-27-05). Is this possible?