Help locating Object Libraries
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? |
Help locating Object Libraries
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? |
Help locating Object Libraries
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? |
All times are GMT +1. The time now is 01:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com