MrExcel Publishing
Your One Stop for Excel Tips & Solutions

macro to close file after saving ??


Posted by Richard Foster on September 03, 2001 9:09 AM

I need a macro that will run automatically when a file opens, and will end by saving the file and then closing it. I can get the first part to work, but can't work out how to get it to close the file after saving it. Any ideas ?? Thanks.


Posted by Dax on September 03, 2001 9:10 AM

Activeworkbook.Close

Regards,
Dax.