Thread: Macro to save to .csv
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote