Macro to save excel file
 

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

Macro to save excel file
 

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