cular directory with a specified name but if it encounters a file of the same name already there and you clkick no to the save it then dies with error 1004. Can anyone assist?Error trapping

[Lost User]

I wonder if anyone can help me? I have a small piece of vba in excel that works fine except for one thing. It saves a spreadsheet in as parti