Sorry, this may be an easy answer, but I dont have it -

Ive got an macro that does some simple manipulation of an excel sheet
- removes header rows, totals, and then sorts the data.

I then use sql to import the data and do a few simple tasks..

The problem is that our excel sheet gets sent to us every day with new
data, and the macro is not part of the sheet. I have to go in and add
the macro myself every day before im import the data.

Is there a simple way (programmatically or other) to quickly have a
macro applied to the spreadsheet and run?

Thanks