title: Create a DLL using VBA editor
body: <p>I have a position where I essentialy write Visual Basic Macros full time to support a number of divisions in the company.  I've done quite well, learned quite a bit, and enjoy my position quite a bit.  </p>
  
  <p>We're laying out plans for the future, and while I'm quite good at searching for information I need for these projects (and stack overflow has been a great resource in that), I've come up dry on something I've been trying to do for a bit.</p>
  
  <p>Here is the lay of the land.  We distribute macros attached to various other programs via a network drive that everyone in the company has access to.  These macros also interface with and automate a proprietary system our company uses.  As such, when slight alterations to that system are made, we have to make alterations to a large number of macros in order to stay up to date.</p>
  
  <p>As such, what we would like to try to do is to make a DLL of methods for interacting with our proprietary system.  We would like to place that DLL on the network drive, and set the reference for all our macros there.  Unfortunately, we do not, at least for the moment, have access to visual studio.  All we have access to as far as development environments go is Visual Basic 6.5 as it comes packaged with office.  We're working on getting more, but any of you that work at a large company know how that goes.</p>
  
  <p>So, I'd like to know if it is possible to create a DLL using the visual basic editor, and if I should expect any issues having dozens of macros potentially accessing it around the same time.</p>
  
  <p>Thanks in advance for any help or advice you may be able to offer.</p>