Hi all,

I'm just finishing up a project, a report creator template.

Which does a Save As, and shows the final format of the document along with a few (new) buttons, for any final adjustments. So it saves my original file under a different name, as an xlsm, and it just deletes some sheets and buttons, and adds some new sheets and new buttons, but it is essentially my original file.

However when the user is satisfied with the final document format I would like to add a button ("Finalize") that saves this final format as an XLSX, under the exact same name as the file it is created from, then it would delete the source file of it.

So...

Original file: ReportCreator.xlsm

'Save as' file: FinalReport_dd_mm_yyyy.xlsm

'Finalize'-d file: FinalReport_dd_mm_yyyy.xlsx

and when I press the button ("Finalize") I would like to be left with 2 files in my folder, ReportCreator.xlsm and FinalReport_dd_mm_yyyy.xlsx (XLSX!!)

I have been reading up on it and it seems entirely possible to me, but I'm not sure how to start that macro for that "Finalize" button.

Could I get some help with this please?