Further to my last I believe that .Value should be inserted after "Debrief_Folder") as follows, but it still doesn't work!

    ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\" & Range("Debrief_Folder").Value & Range("Ex").Value & " " & Range("Name").Value & " " & Format(Dt, "dd-mmm-yy") & ".xls", FileFormat:=xlNormal
Regards