Thanks, all for your answers. Rob's original code allows me to save the
file in any directory I want. My intent is to force a particular filename
convention but allow a user the flexibility to save it in whatever directory
they choose.

The cell in the filename is the name of the first person that the form deals
with, so the filename comes out as "TCRSomeone.xls". That way, when I see
it in my records, I can more easily find a file.

Thanks again!