Save CSV File without prompting


C

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

Advertisements

T

Tom Ogilvy

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

Activeworkbook.Close SaveChanges:=False
 
G

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
 
Ad

Advertisements

G

Guest

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

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

Top