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?

Assuming that you have the right to distribute the DLLs, you need to
copy all the DLLs to the user's PC, often, but not necessarily, to the
C:\Windows\System32 directory. The actual location of the DLLs isn't
terribly important, but they should reside in a location that the user
isn't likely to delete them.

Once the DLLs are on the target machine, you need to run RegSvr32 to
register the DLLs with Windows.

On each target machine, go to the Windows Start menu, choose Run, and
enter the following with the quotes as shown:

RegSvr32 "C:\Folder\Path\FileName.dll"

and press OK. Of course, change "C:\Folder\Path\FileName.dll" to the
fully qualified file name of the DLL in question. If you are
distributing more than one DLL, you need to run RegSvr32 for each DLL.

If you are using an installer package like InstallShield, Advanced
Installer, or Setup Factory, you can configure the installer to
automatically register the DLLs so you don't have to run RegSvr32.

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


On Fri, 6 Nov 2009 09:39:01 -0800, Ayo
wrote:

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?

It is quite possible, if you know the name of the library reference.
You can try adding it like

Thisworkbook.VBProject.References.AddFromFile FileName:="C:\Program
files\Common Files\(name of your reference)"

Just substitue this with your directory and reference name



"Ayo" wrote:

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?