How to attach a macro so it runs when the file is opening from another program (an ERP)

I run a report out of a business ERP system and one of the output options is excel.  When it opens in excel the format has many issues and the program developers are unable to make any more changes to help with the formatting.  I have created a macro to fix the formatting but that requires all my users to have the macro and use it after opening the excel file.  

Is there a way to permanently attach the macro to the excel file so it can run when the report is being sent to excel?  Does that make sense?  Thank you in advance.  

By: Kristin Rigda

Leave a Reply

Your email address will not be published. Required fields are marked *