Use a visual studio 2022 DLL in office 365 64-bits

Hi,

I have a problem to use a code compiled with Microsoft Visual Studio 2022.
Basically the code generates a dll that takes an argument and returns another to an Excel cell. The code below works correctly in the 32-bit architecture of Office (generating code like Win32), but gives an error when receiving the variable "a" in the 64-bit version of Office.

double __stdcall fA(double& a) // causes an exception reading "a" - only in 64 bits mode
{
return a;
}

If I change the code to:
double __stdcall fA(double& a) // caues an exception reading "a" - only in 64 bits mode
{
return 5;
}
the number 5 is displayed correctly in corresponding Excel cell.

At the VBA module…
Declare PtrSafe Function fA Lib "C:\mydll.dll" (ByRef a As Double) As Double

Does anyone have any idea what this problem could be or the root cause of it?

C++
web



Hi,

I have a problem to use a code compiled with Microsoft Visual Studio 2022.
Basically the code generates a dll that takes an argument and returns another to an Excel cell. The code below works correctly in the 32-bit architecture of Office (generating code like Win32), but gives an error when receiving the variable "a" in the 64-bit version of Office.

double __stdcall fA(double& a) // caues an exception reading "a" - only in 64 bits mode
{
return a;
}

If I change the code to:
double __stdcall fA(double& a) // caues an exception reading "a" - only in 64 bits mode
{
return 5;
}
the number 5 is displayed correctly in corresponding Excel cell.

At the VBA module…
Declare PtrSafe Function fA Lib "C:\mydll.dll" (ByRef a As Double) As Double

Does anyone have any idea what this problem could be or the root cause of it?

C++