Using DLL in VBA

Thank you for the suggestion. The DLL is a 32-bit DLL and I'm having the same problem in both Windows XP and Windows 7 (64-bit). Excel 2010 is the 32-bit version also.

The DLL is a third party DLL and here is the declaration for it:

Declare Function pp_libtest Lib "KeyLBE32.dll" (ByVal testnum As Long) As Long

The file is in my System32 folder. I've also tried putting it in a different folder and changed the declaration to point there. Same problem.

The really weird thing is that on the computer that has both Excel 2007 and 2010, it only works on 2007. That's even when I open up the same file in the same location. And the DLL is located in the same location.

Headpygmie