View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alok Alok is offline
external usenet poster
 
Posts: 318
Default HOW 2 Auto Close and Save CSV file

Application.DisplayAlerts=False

"WANNABE" wrote:

Hi, all... I am trying to copy some values into a CSV file then close and
save both files. When I use ActiveWindow.save or ActiveWindow.Close on the
CSV file it prompts my if I want to save it as is, and OF COURSE I DO...
How can I accomplish this with out the prompts??? Thank you again....