I have developed a simple Neural Network Script for energy predictions that I want to use using Excel. Therefore I want to develop an Excel add-in for that.
Before I begin let me tell you that I am using Windows 7 64-bit, Microsoft Office 64-bit as well as Matlab R2012a 64-bit.
So, my first step was to turn my script into a function and then using the deploy tool create an Excel add-in. In the folder created I get a src (source) and a distrib (distribution) folder. I know that distrib is the folder I'm supposed to use when distributing my program.
In my computer I used my .bas file that I imported in Excel thus I was able to import my function in Excel. And everything here works perfect.
However, when I try to another computer that has the MCR compiler but not MATLAB I do not seem to be able to succeed. I try to import the .bas file through the VBA tab in Excel but I get error messages.
I was wondering if someone could provide some step by step help for me on how to develop an Excel add-in that can work in all computers, irrespective of 64-bit, 32-bit, dll files etc...