ActiveWorkbook.Close SaveChanges:=True

--
Regards,
Tom Ogilvy

"jc lewis" wrote in message
om...
I have created a macro that imports a .txt file and does the import
wizard thing. How you can have excel save and close the file at
completion without all those annoying save prompts?


Thanks
jc lewis