I am using excel to run the majority of things with VBA but our server also
has VBA which i use to pull daily reports from in the morning then open in
excel.

Is there a way to get this to interact with Excels VBA so i only need to run
one macro to pull the reports off, then activate the macro to inport the
files rather than running the two, and could this be done from Excel?