Macro to save to .csv
 

Hello everyone,

I'm creating a macro that saves Sheet1 to a comma delimited file(CSV)
However whenever I ran the macro, it keeps asking me if I want t
overwrite the existing file. Anyway to force the macro to overwrite th
file without prompting me

--
ledzep
-----------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...fo&userid=2520
View this thread: http://www.excelforum.com/showthread.php?threadid=39002

Macro to save to .csv
 

application.displayalerts = false
'your code to save as .csv
application.displayalerts = true



ledzepe wrote:

Hello everyone,

I'm creating a macro that saves Sheet1 to a comma delimited file(CSV).
However whenever I ran the macro, it keeps asking me if I want to
overwrite the existing file. Anyway to force the macro to overwrite the
file without prompting me.

--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=390023

--

Dave Peterson