VBA Overwrite Existing File
Posted by Richard S on July 05, 2001 1:03 AM
I have recorded a macro which opens a blank file, copies data and format from another file, then saves it as a specific name. It then emails the workbook, closes it, then repeats for the next workbook. The only problem is, when he Macro gets to the command "ActiveWorkbook.SaveAs" command, I get a prompt that the filename already exists, and do I want to replace it. I have no need to keep the file, so I answer yes. Is there a command which will do this for me, as the Macro repeats about 150 times, and I don't want to sit there clicking yes all the time.
Any help appreciated