View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default pop ups after saving to csv via macro

Actually, since the workbook has just been saved

ActiveWorkbook.Close SaveChanges:=False

my be a better choice.

--
Regards,
Tom Ogilvy

[Wizard] wrote in message
...
Try

ActiveWorkbook.Close SaveChanges:=True

That should do it.