I'm in a company that has very locked down computers, but I want to be able to write an Excel self-service data tool for both Oracle and Teradata back ends. The problem is, Excel doesn't natively connect to either, unless you install the drivers on each user's machine, which is not possible for us. In addition, we have people on versions from 2007 to 2012, so I cannot assume a specific version is in use.

My idea is that if I create an add-in that has the drivers built in, along with some exposed functions I can use from VBA to send or receive data, then I can store it somewhere easily accessible (such as Sharepoint), and have the VBA on my spreadsheet grab it and auto-install if it's not already on an individual user's machine. It would have to be installable without admin rights on the user's machine as well.

Is this possible, and if so, has someone already done it so I can just grab it instead of writing it on my own?

Thanks in advance!