Thanks for that. I wouldnt go for the second option, Its way beyond my capabilites.

There are lots of docs on the internet saying you can add a script task in Integratin services and then deploy the vBA script from their (The macro)

bu then it all gets vague and doesnt tell you the specifics on how to do it. Its very frustrating. I have code which works and an IS package to add it too.

I just dont have the bit of script that would call the macro wthin the package.

I have a meeting with my boss tomorrow where Im going to tell him Ive been beaten. Gutted!