Using a macro when opening an excel spreadsheet
 

I have seen though the forum how to open a macro automatically, the AUto-Open
macro works perfectly. My problem is that I'm using a macro in access to
create an .xls file and then I want the excel macro to run but the access
creates a new excel file each time and the macro is not in it. How do I get
the macro to save each time

Thank you