Macro Help - Get rid of prompt when trying to save a file ov

[Uli]

I'm just new here but I'm in need of some help with a really simple Macro I'm just working on:

I am basically opening a file and then using Save As to save it with a different file name. That new file name already exists so I get the prompt that the file already exists and whether I want to overwrite the file. The answer in this Macro is always "Yes" to overwrite and I have to open about 100 worksheets. That's why I want to do this automatically and I don't feel like having to click on the prompt 100 times to keep the Macro running. I've got it all worked out except for how to get rid of that prompt in my code.

Any suggestions? Is it possible?

 

[anno]

uli
the 'display alerts property' topic in the vba help file suggests this as an example of how you'd do that:
Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True
from reading the help file i think it applies to any alert in excel, but i know very little about vba - someone else will no doubt know.
hth

 

[Uli]

Thank you very much. That works like a charm. I really appreciate the help. I feel a bit silly because I did look through all the help I could find but in my panic (major deadline looming) I didn't think to search for the right keyword.

Thanks for your help. It's appreciated.