Thanks

I put in the "Before Save" application and it works like a charm

"JP" wrote:

This is exactly what Bob's code does.

--JP

On Sep 23, 11:05 am, Zee wrote:
Thanks for the help and this works however the specific cell that is going to
be the filename will not be entered in until the file is opened as a read
only as currently this cell is blank.