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