Only problem is that I need an individual name for each file saved. This
saves into same file name over and over.

"Ron de Bruin" wrote:

Hi Rob

Use this

Application.DisplayAlerts = False
'Save code
Application.DisplayAlerts = True


--
Regards Ron de Bruin
http://www.rondebruin.nl


"RobMack" wrote in message ...
I have a procedure whereby files need to be automatically saved, "save as".
How can I code the procedure so that it will rename the file and I don't get
the error message that "file already exists, do you want to replace"?