Macro to automatically save a ‘.xlsm’ file to an ‘.xlsx’ file in the same folder

Hi,

Can anyone please advise me of the macro code I need to run from my template file which has the ‘.xlsm’ extension to automatically save it as a normal ‘.xlsx’ file, which in the process not only converts the file but will lose any in-built macros etc. The new ‘.xlsx’ file must be saved in the same file location as the original ‘.xlsm’ file and must be a totally automated in that the user will not be required to answer any prompts to confirm etc

Many thanks in advance for any assistance received

Regards

Rob

Look at this link for a couple of solutions

http://www.mrexcel.com/forum/excel-q...lications.html