I would like to have a template .xlt file which, when three cells have been completed (and they must be completed!) automatically saves the .xls file in the one folder with the file name made up of the concatenated cells data.

This is in part linked to this 'Prevent Save unless cells are complete' thread
http://www.excelforum.com/showthread.php?t=625297

This would then ensure that my users would always get the file naming protocol correct!

The three cells have been named as ExIncOp, Name and StartDate. StartDate has been formatted to appear as dd-mmm-yy.

I have put the formula 
=(LEFT(ExIncOp,2) & " " & Name &  " " & StartDate)
in one cell which produces what I want except that the date is no longer formatted dd-mmm-yy and then recorded a macro to save the file

Sub SaveFile()

' SaveFile Macro
'
    Range("M6").Select
    Selection.Copy
    Application.CutCopyMode = False
    ActiveWorkbook.SaveAs Filename:= _
        "H:\........\Ex Test 39417.xls", FileFormat:=xlExcel8 _
        , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
        CreateBackup:=False
End Sub
which unfortunately did not allow me to paste what I had copied from the concatenated cell into the file name field.

Is this possible?