Early binding reference list, add all?

**Jaymond Flurrie** · 09-01-2008, 10:11 PM

I'm studying about early binding from an Excel VBA book, and it seems like everywhere is said "create a reference to...". Since I have a lot of programs in my list under tools->references in VBE, should I just check everything so they are referenced? Is there some certain reason why not to do that? Does it slow down my code?

**shg** · 09-01-2008, 11:38 PM

Early binding speeds execution and supports Intellisense. Include only the references you need; why include others?

**Jaymond Flurrie** · 09-02-2008, 12:31 AM

Originally Posted by shg

Early binding speeds execution and supports Intellisense. Include only the references you need; why include others?

Well, for example for VSTO there's like 50 different references. How do I know which one I need?

**Andy Pope** · 09-02-2008, 03:45 AM

The ones required for most normal coding of the Excel application are automatically included. If you add a userform the MSForms library will be also be included.

You only need to add references when using something not standard in excel.
For example if you used excel to automate Powerpoint you would include a reference to the powerpoint library.