Save xlsm file as xlsx file

[ccpsc]

Hi,

I have a xlsm file which I need to save as an xlsx file with the same name, in the same folder and over write any existing file (Which may exist due to previous use).

Thanks in Advance

[shg]

Please Login or Register  to view this content.

[FDibbins]

or you could just use save-as, and select xlsx from the drop-dpwn save-as list, and just overright whatever file may or may not be there?

[ccpsc]

Thanks shg that works. I also need the code to close the .xlsx file and re-open the .xlsm file, can you add that? Thanks

[ccpsc]

I got it to work, not sure if it is good code but it does the job

Please Login or Register  to view this content.