Export a specific page with tables from word template to excel spreadsheet

[Aussiebear]

I need help to write a macro to export the last page of my template to an excel worksheet

Have you considered saving the "last page of your template" as an Excel template in its own right and then join the two workbooks?

and the document in a normal word document when user hit the command button.

Which program (Word or Excel) are you in when the command button is activated?

I manage to write the macro that can allow user to open the save the doc, but have no idea on how to convert the last page to excel.

What exactly is the template you have constructed? I'm confident that the "allow user to open the save the doc" is a typo but can you reconstruct this bit as well please?