I get daily an xls report in my outlook email against which I would
like run some VBA code

Where should I keep this VBA code?
Storing in sheet or workbook won't help because I get a new xls daily.

I am a beginner to excel programming.

Thanks for your help.