Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA: Cannot Find Project or Library

Status
Not open for further replies.

arst06d

Programmer
Nov 29, 2002
324
Hi

I have an Excel addin which references a vb6 dll.
The dll has been recompiled with binary compatibility set for the previously compiled version.
the dll is installed into c:\windows\system32 and registered using regsvr32.

In Excel, when I Tools>AddIns, select the addin and click OK, I get "Cannot find project or library". When I access the references in the xla, I see "Missing: Batch processor tasks", being the dll.

But it is installed, and it is registered.

If I remove the reference, then remake the reference then all is well.

However, I only want to distribute the dll.

Further confusion in that the above behaviour occurs when I am logged in as an AT user. When logged in with local admin, I get no problems at all.

Any pointers will be appreciated.
 
You ccould try to save excel file (xls) with proper dll reference as add-in (xla) - you cannot save changed 'xla' file, so it can keep wrong references.
In excel, check the location of referenced 'xla' file, excel used to save custom add-ins in user document & settings directory.

combo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top