Running a Excel VBA Addin from Applescript

Hi,

I have created a VBA script in Excel 2011. I want this scripot to be availbale to any workbook I open up in Excel so I have set the script as an Add-in. Then I want to be abke to run this script from Applescript. The final plan is to have an automater workflow which allows me to drag and drop an excel file onto it which will open the file, run the script I have told it to run and save the file again.

I think it is a referencing issue I have, I'm using the "run VB macro" command but I am getting the referencing wrong somewhere along the line. If anyone can help or point me in the direction of some good documentation it would be really helpful.

Thanks