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?
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?