Hi, I've just written my first VB.Net Class Library in VS 2010 and I now want to reference it from Excel. When I attempt to add the reference, however, Excel returns the message "Can't add a reference to the specified file."
Is there something I need to do at the build stage to make my dll compatible with Excel (2007)? I'm very much a noob with .Net - my experience is VBA based - so I appreciate that the answer may not be so straight-forward. In which case a shove in the right direction of where to go and do some further research would be appreciated. In case it's relevant, the dll is the beginnings of an API which currently 'should' provide a method to fetch data from an SQLServer db. It will accept the name of a stored procedure and any required parameters of the stored procedure and return an OleDbDataReader object.
