What object libraries are missing? You may be able to write your code so
That probably wouldn't help. If Windows can't find the typelib based
on the GUID, which is how References in VBA are accessed, it isn't
likely that the typelib can be found when a GetObject or CreateObject
is executed. Late binding allows you to omit the Reference, but it
still requires that the typelib and the codelib be discoverable so
that all the COM plumbing can work properly. If the VBA References
displays "MISSING", it is unlikely that late binding will do any good.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)