I have a DLL that was developed under the .NET framework. It is a mathematical model used to calculate some returns. Anyways I need the ability to call the functions from within an Excel macro... The inputs for the model will come from the excel spreadsheet. The problem is I went to VB editor -> Tools -> references -> browse... then I attempt to open the .NET .DLL.... then I get the error message "Can't add reference to the specified file." If you have any experience with VBA and calling .NET DLLs any advice would be very helpful.

Thanks,
brazilnut