VBA找不到我的DLL，尽管硬编码位置。

我使用C ++创建一个简单的DLL，我可以使用从VBA代码。然而，虽然它在我的开发计算机上工作，当尝试访问不同的计算机上的DLL，VBA说明没有找到DLL文件，尽管硬编码的路径。

I am using C++ to create a simple DLL that I can use from VBA code. However, while it works on my development computer, when attempting to access the DLL on different computers, VBA states the DLL File was not found, despite hardcoding the path in.

我的DLL看起来像这样（使用Visual C ++ 2010 Express作为Win32 dll项目创建）：

My DLL looks like this (created with Visual C++ 2010 Express as a Win32 dll project):

DEF文件：

LIBRARY "squareNumber"
EXPORTS
squareNumber

$ b b

Function.cpp：

Function.cpp:

double __stdcall squareNumber(double & x)
{
    return x*x;
}

VBA代码如下所示：

The VBA code looks like this:

Public Declare Function squareNumber Lib "C:\MySimpleDLL.dll" (ByRef number As Double) As Double

Sub test()
    MsgBox squareNumber(2)
End Sub

，我编码的dll错了，还是它的VBA的问题？

I am very new to C++ DLLs, did I code the dll wrong, or is it VBA's problem?

使用RegSvr32也会产生模块[dllpath]加载失败，确保二进制存储指定的路径或调试它检查二进制或依赖.DLL文件的问题。

Using RegSvr32 also yields "The module [dllpath] failed to load. Make sure the binary is stored at the specified path or debug it to check for problems with the binary or dependent .DLL files."