How do you replace an existing file, saying "yes" in a macro?

C

Chris

Ok, I have a macro set up that creates an excel file using
different criteria. I have it create 5 "alternatives"
that each is a different file. After 5, you are not
allowed to create any more. If you try to create another
one, a message box pops up saying, do you want to replace
the existing file? The file already exists, and if you
say "no", or hit "cancel", my macro bombs out because of
the saveas property. Here is an example of my code:

ActiveWorkbook.SaveAs ("C:\" & pname & "-" & tod_month
& "_" & tod_day & "_" & tod_year & "_" & Alt_Name)

ActiveWorkbook.Close

It always bombs out at the SaveAS line. Any help would be
greatly appreciated. Email me if you have a solution.
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Save As problem with file that already exist 3
Save As Then Replace Bombs Out 2
SaveAS dialog box gives run time error 1004 in Excel VBA 3
Failure at File Save 2
How do I convert a macro that was created in 2003 Excel to 2007 8
SaveAs macro: How do I specify "Replace existing file?" 1
Choosing no when asked to overwrite an existing file? 1
how to save a file and overwrite existing file 1

Top