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.