View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
guidop12 guidop12 is offline
external usenet poster
 
Posts: 5
Default 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