Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help locating Object Libraries
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) On Fri, 6 Nov 2009 09:51: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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help locating Object Libraries
What object libraries are missing? You may be able to write your code so
that it is late binding. "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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help locating Object Libraries
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. "Barb Reinhardt" wrote: What object libraries are missing? You may be able to write your code so that it is late binding. "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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help locating Object Libraries
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) On Fri, 6 Nov 2009 10:11:03 -0800, Barb Reinhardt wrote: What object libraries are missing? You may be able to write your code so that it is late binding. "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help locating Object Libraries | Excel Discussion (Misc queries) | |||
Object libraries and different ones with different versions | Excel Programming | |||
Office Object Libraries | Excel Programming | |||
Using Outlook Object Libraries V8 & 9 | Excel Programming | |||
Object libraries | Excel Programming |