Good day all,

I'm having a particular issue with calling a vba function in an excel file from MS Access. The vast majority of what I want to do is working, but I'm having trouble when I try to run a function that relies on an external addin - Smartview for Hyperion. Here's the deal -

1. The function runs flawlessly when I open the file directly in excel. There is a ticked reference and a module imported to work alongside my code.
2. When I call other functions that just rely on the excel 14 library in access, all is well.
3. So, my access code opens excel, opens the workbook with the code in it, and runs it with the excel.application.run function.

Any help would be much appreciated, an my apologies in advance if I'm contravening any forum rules or etiquette with this.

Shane