Hi Norie,

Thanks to a suggestion from a colleague I’ve managed to solve this with a workaround; I’ve added code in to save the new workbook as “Temp” in a specified folder. This allows me to move between workbooks and do what’s required, then save the “Temp” workbook as the correct name and delete the “Temp” document from the save folder.
If you have a more elegant way of doing this I’d still love to hear it (I’m fairly sure none of my VB coding is by any means elegant!)
Thanks for the help either way.
Regards,
Craig...