How to link an application to Macros?
 

We are pulling out reports from a application on a daily basis and exporting
that to a excel sheet and some modification are done to that report , my
question is the first part pulling the data from the application, is there
any way of linking that application to the macros?