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-

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

Activeworkbook.Close SaveChanges:=False

--
Regards,
Tom Ogilvy


"Chris" wrote in message
...
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-

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

"Tom Ogilvy" wrote:

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

Activeworkbook.Close SaveChanges:=False

--
Regards,
Tom Ogilvy


"Chris" wrote in message
...
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-

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

"Rob K" wrote:

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

"Tom Ogilvy" wrote:

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

Activeworkbook.Close SaveChanges:=False

--
Regards,
Tom Ogilvy


"Chris" wrote in message
...
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-