Re: $$Excel-Macros$$ AutoSaveAs

2010-11-16 Thread enquirer
Thanks ever so much for your help Paul. On Nov 16, 1:12 pm, Paul Schreiner wrote: -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.

Re: $$Excel-Macros$$ AutoSaveAs

2010-11-16 Thread Paul Schreiner
You can create a BeforeClose event in which you save the file before exiting. To do it yourself, first, record a macro in which you do a SaveAS (specify file) Then, in the VBA editor, choose the Thisworkbook module. In the upper left pull-down, select Workbook in the upper right pull-down, select