save as
 

Hi
I'm writeing a macro that list's a directory in a spreadsheet then saves to
that directory. It works fine the firs time round but next time it's run it
is asking to overwrite the previous file. I want it to overwrite without
asking. there is around 1000 folders that it saves to so it's a bit tedious
pressing ok 1000 times. is there any way to do this?

cheers

save as
 

step,

Try
Application.DisplayAlerts = False
before the save code
and set it back to True afterwards.

John

step wrote:

Hi
I'm writeing a macro that list's a directory in a spreadsheet then saves to
that directory. It works fine the firs time round but next time it's run it
is asking to overwrite the previous file. I want it to overwrite without
asking. there is around 1000 folders that it saves to so it's a bit tedious
pressing ok 1000 times. is there any way to do this?

cheers