When trying to save and close a CSV I get prompted
with...Do you want to save changes to file.csv, then after
choosing Yes I still get the SaveAs dialog box and have to
choose Save, and then again am told that now it already
exists, do I want to replace?

User ends up having to respond to 3 pop-ups from Excel.
Is there a way to have these default to Yes/Save? Here is
my simple close code..

ActiveWorkbook.SaveAs Filename:="L:\#FACRR1
\VendorReleaseDetailForImport.csv", _
FileFormat:=xlCSV, CreateBackup:=False

I have tried SendKeys but I dont think the VBA gets to
that line of code because it is not yet finished with the
Save so I cant just send keystrokes to say Yes, Save,
Yes. Any help would be greatly appreciated.

c-