overwriting a file without the pop up

[justchris]

Ok, i know how to save the file through vba, but what i dont know is how to make excel NOT ask to overwrite, i need this done automaticaly, Any help would be awesome

Thanks
Chris

[Roadie]

You could use:
Application.DisplayAlerts = False
or
Workbooks(filename).Close SaveChanges:=False

[justchris]

Thanks! That's what I was looking for.