Question about using DLLs in Excel 2010
Posted on 2011-09-15
Hello all. I think Excel 2010 is the proper spot for this question.
I have some VBA code that calls an ActiveX DLL (VB6). The DLL actually also calls a normal DLL to get some information. I pretty much don't want to call that normal DLL in VBA. Anyway, this has been working fine for all Excel versions from 97 to 2007. But now, I get an error in 2010.
It says that it can't find the normal DLL file.
The weird thing is that I have both 2007 and 2010 on my computer and it's using the exact same files (and directory location). It works in 2007, but not 2010.
Any ideas on this? Does 2010 process DLLs differently?