Hi Ross!

Thanks for reply. It is indeed Excel files I am working with. It uses just one sheet in the workbook. When I recieve the file it is called something along the lines of SEI Inspector Credit Report 17.12.2009 and I would like to save it as something along the lines of '17.12.2009 SEI Report'.

This is to be the beginning of a much larger macro but I thought I would ease myself in gently!

Is your name anything to do with the Leith here in Edinburgh?