Using DLL in VBA

[headpygmie]

Hello. I have a workbook that accesses a DLL in the VBA code. The workbook works fine in Excel 2007, but it gives me a "can't find file" error in Excel 2010. The file it can't find is the DLL.

I have both 2007 and 2010 on the same computer. And I am opening the same exact file in the same location in both versions. So it's weird that it works in one, but not the other.

Any idea? Does Excel 2010 process a DLL differently?

Thanks,
Headpygmie

[Leith Ross]

Hello headpygmie,

Welcome to the Forum!

It is impossible to say what the problem with the DLL is without knowing the name of the DLL and seeing the code you are using to access it and knowing more about your system's operating system, like is it a 32 bit or a 64 bit version of 2010?

[headpygmie]

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

[Leith Ross]

Hello headpygmie,

The 32 in the name indicates it is for a 32 bit OS. Do you know for certain that the DLL has been registered on the system?

[headpygmie]

Yep, that's what I was thinking. But it is definitely registered properly. The Windows 7 system is where I have both 2007 and 2010. And it works fine when I open it up in 2007.

And I also get the same error when I open up the file in Excel 2010 in my Windows XP system.

HP

[Leith Ross]

Hello headpygmie,

Are you running Excel 2010 under Windows XP?

[headpygmie]

Yes, I am.

[Kenneth Hobson]

Try Regsvr32 and register it.

[Leith Ross]

Hello headpygmie,

I can't say for sure because I am not familiar with your DLL but based on the behavior it is accessing one or more calls that are specific to Excel 2007. Do you know if the DLL is design to run on platforms other than 2007?

[headpygmie]

It's one of those DLL's where you don't need to register. You just need to declare it (which I have).

I tried it anyways and got an error, which I expected.

[Kenneth Hobson]

Does the error happen at design time or run time?

[headpygmie]

It happens at run-time when I'm calling that routine.

[Kenneth Hobson]

Try a simple function in the DLL. It is probably a problem with that function.

[headpygmie]

I've tried other functions in that DLL and I have the same problem. It just can't seem to "find" the DLL. But I've also tried another DLL from a different company and that one worked fine. So it's not all DLLs.

My main concern is that the DLL works fine in Excel 2007 but not in Excel 2010 (and both Excels are on the same computer). What is 2010 doing differently?

[suhas.nehete]

Hi Headpygmie

Same problem is with me too. I am also trying to connect with third party DLL in Excel 2010 but it gives error that Microsoft Excel stopped working and excel gets crashed.
While same file run smoothly in Excel 2007. Problem for me to use 2007 is that, I want to use sover in same excel sheet and excel 2010 solver is better than 2007.

Please help us out
Suhas