Standalone Excel Macro

I have a report that I run from the system once a week, and the data is exported to an excel document. I have set up a tool that exports data to excel in order to do a decent job of formatting, but there is still more that I need to do when the data is in excel.

Is it possible to create a stand-alone macro, save it in the Microsoft Office folder and be able to call it after opening this file? I wrote many macros that are part of the ONE of this spreadsheet, but have never tried one that was open to many spreadsheets.

Is it possible, and the initial direction of good resources, where I can learn how to achieve this goal? Thank.