Nae bother. You dont want a broken furnace at this time of year!

Thanks for that. That code works great but not quite what I am looking for.
To be more specific I suppose I would like an input box for user to enter date because I dont want to give the user a choice of what the file is called or where it is stored.
So for example I would like the Input box to say 'Please enter date of Report' and once the date has been entered in box and OK has been clicked , the macro would then go on to Save As in a pre-specified folder. (for purpose of example folder would be C:\Chambers-Smith\documnets\work)

Andy