View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JON JON JON JON is offline
external usenet poster
 
Posts: 62
Default VB Help (Excel Warnings)

TRY

Application.DisplayAlerts = False
your code here

Application.DisplayAlerts = True

"Alastair79" wrote in message
...
I have a .CSV file which I have created a macro to go through and sort
data.
But when I save it I have about six million warning messages asking if I'm
sure I want to save my work.

Can I set the warnings to false and close the sheet from within my Macro?

Thanks............. Alastair.