title: Calling a .net library method from vba
body: <p>I have developed a web service in ASP.net, c#, and hosted on IIS, which is to be consumed by a vba client. Having downloaded the Office 2003 Web Services 2.01 Toolkit, I encountered a problem in successfully creating the proxy classes required (as documented by many users online), and decided to create a .net dll library instead. I have created the library, which references the web service and exposes one of its methods to a public function in c#. </p>
  
  <p>I now have three questions:</p>
  
  <ol>
  <li><p>How do I reference the dll class in VBA? I tried to go to Tools->References and browsed to the dll location, but I get the error "can't add reference to the file specified". Is there a specific location on the disk I have to have the .dll copied? </p></li>
  <li><p>Can I also copy the dll.config file next to the dll file, so as to have the endpoint url there?</p></li>
  <li><p>Since the method to call is accepting an object (consisting of various members and a couple of List&lt;> members, how are these to be implemented in VBA code?</p></li>
  </ol>