$$Excel-Macros$$ Re: Excel add-in and Reference in VBA

2009-06-16 Thread zheng yu
Thanks ! Paul! this is very thorough and precise! Thanks so much. Sometimes, I can feel the differences..but can' t summarize and tell. i guess it is because I don't understand too deep. Again,thanks so much Vincent On Mon, Jun 15, 2009 at 5:50 PM, Paul Schreiner wrote: > Without get

$$Excel-Macros$$ Re: Excel add-in and Reference in VBA

2009-06-15 Thread Paul Schreiner
Without getting into how Excel stores, saves and distributes the two, here's how they are USED. "References" are libraries (usually .DLL's) that are distributed with the the Excel application. These may be "activated", or left unused. Let's say, for example, that you wish to use VBA to access a L