Hi,

I do have a question abouth the Tools - Reference in the VB editor
(Excel 2000).

Is it possible to add programmaticaly references in the Workbook_open
event in run time?
If so, how to do so?

Question comes from some problems i encounter in distributing my
utility on 2 other PC's, located at around 70 miles from my home.
Normally, in design time, you select the nessesarry library's to work
with (example MSMAPI.OCX, FM20.DLL). but the other PC's does'nt have
those librarys selected.
So, the idea rise to write some code in the Workbook_open event to
find the location of the nessesarry librarys (OCX, DLL, ...) and
select them. This would be more convienient then hanging on the phone
with someone who knows nothing abouth the VBE and selecting those
library's. There's also a problem if those librarys doesn't appear in
the list and have to be found manually.

Any help welcome.
Regards,
Ludo