Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 767
  • Last Modified:

Using a 3rd party DLL in Excel.

I am trying to use a third party library (elanescale.dll for a scale for counting/inventory of  items from elane.net)

I am using Windows7 (x64) with Excel 2007.
I have used regsvr32 "C:\MyDLLs\ElaneScale.dll", I see the file in windows\system32 when I use explorer. However, when I try to add it to references in VBE, i cannot find it. I have tried to browse from the reference manager in windows\system32, but I cant see it.

When I late bind it, I can use the object browser and find the library and see the functions, but when I try to use it, I get a entry point not found (I am not real familiar with late binding)

What am I missing?

Thanks

Bruce
0
Bruj
Asked:
Bruj
  • 2
  • 2
1 Solution
 
Robert SchuttSoftware EngineerCommented:
If you're using a 32 bits Office (or it could be related to VBA in general), you may need to use C:\Windows\SysWOW64\regsvr32.exe (unregister the existing first).
0
 
BrujAuthor Commented:
Thanks! That was not all of my issue, but it got me to the point where I could find the rest! I got it working!

Have a GREAT DAY!
0
 
BrujAuthor Commented:
Thanks! That was not all of my issue, but it got me to the point where I could find the rest! I got it working!

Have a GREAT DAY!
0
 
Robert SchuttSoftware EngineerCommented:
Same to you! ;-)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now