Can you post the code you are using?

Or, maybe this sample of code I use for file "replacement" will help...

ActiveWorkbook.SaveAs FileName:="c:\Readymix\" + savedfile,
FileFormat:=xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False, CreateBackup:=False


"Stan Halls" wrote:

this might be an easy one for someone in here , i have a short script that
saves a file in 2 places by over writing the exsisting files, when i run the
script i get a box that requires me to click on it to overwright the file....
how can i get the script to do this without asking ?
thank you in advance for your help

Stan