I am exporting data from Access to excel using a vba routine in access. I
also need to create a macro in in the Excel sheet. The VBA creates a copy of
a template I have created. The data is loaded in the new copy of the
template. I recorded a macro to subtotal columns in the template.

The problem is after I load the data the Macro is no longer in the spread
sheet. How can I load the data then run a macro in the sheet to subtotal the
columns?