spences10 / VBA-IDE-Code-Export

Export & Import VBA code for use with Git (or any VCS)
MIT License
119 stars 34 forks source link

`Add References` clearly detailed in the code #77

Open spences10 opened 7 years ago

spences10 commented 7 years ago

@mattpalermo I'm not sure if this is taken care of anywhere already but

Here's my experience, have the source code somewhere on your machine, go to build the add-in, so for me I know how to build the Excel .xlsm from the source then add the modules all groovy, then I compile...

I know that there are some refs need adding and I could just go through and hit compile and add in the references on what error messages I get back

Or I have to go back to the documentation and find the list

What I'm thinking is that the list is added to the first module the user will see,

image

So maybe add in some comments:

image

Add in the following references:

  1. Microsoft Scripting Runtime
  2. Microsoft Visual Basic for Applications Extensibility 5.3
  3. Windows Script Host Object Model
  4. Microsoft Shell Controls And Automation

Now that I've just added them to the config .cls I may just leave them in there

Let me know what you think

mattpalermo commented 7 years ago

Good points. Easier the better. I think it's a bit weird to put it in an arbitrary module. Think about what happens when that module is no longer the first to show up. Have you considered creating an empty module with the comments and naming it such that it will always appear first? I'm not sure if this is possible but if you name it something like "aaa_references" it might show up first.