Save CSV File without prompting

[Chris]

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-

 

[Tom Ogilvy]

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

Activeworkbook.Close SaveChanges:=False

 

[Guest]

Is there something analagous available for closing a file (in this case a csv
file) to avoid the discard/save message that pops up alerting the user that
there's a large amounts of data in the clipboard?

I would like to be able to close my csv file after copying the data from it
and automatically discard the data saved in the office clipboard.

Thanks in advance!
Rob

 

[Guest]

I found my answer I found a thread from Ron Bovey. I used the
Application.CutCopyMode=False and that did the trick.