Help locating Object Libraries

[Ayo]

I developed an Excel macro but some people can't use it because they don't
have the object libraries needed in their Excel application. How do you add
object libraries to your VBA that are missing?

 

[Chip Pearson]

See my reply in the misc group. In summary, copy the DLLs to the
target machines and use RegSvr32 to registry them with Windows.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Barb Reinhardt]

What object libraries are missing? You may be able to write your code so
that it is late binding.

 

[Ayo]

I am not sure exactly but my VBA has the following:
Microsoft Excel 12.0 Object Library
Microsoft Office 12.0 Object Library
Microsoft Forms 2.0 Object Library
I'm not sure how many more he's missing

and he could find the same Library in his version of the application, even
though he has Microsoft Office 2007.

 

[Chip Pearson]

What object libraries are missing? You may be able to write your code so

that it is late binding.

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)