Hi
I need help to write a macro to export the last page of my template to an excel worksheet and the document in a normal word document when user hit the command button.
The function can just open the spreadsheet with the converted info, no need to save the spreadsheet for the user, same as the word document.

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. Any assistance is appreciated. Thanks.