Macros are run directly inside of Revit and are saved in the project file. Other applications, like MS Office, provide the ability to record macros directly from your actions on the screen.