AddressOf Operator VBA x64 not working

[Mohsin Malik]

Hi, I am getting data type mismatch on AddressOf operator. Is there any alternative available that I can use instead of AddressOf that is compatible with 64bit Office?

Thank you
Mohsin

 

[Uncle Gizmo]

Have you added PtrSafe?

 

[CJ_London]

you also need to change pointer type longs from long to longlong or longptr

 

[Mohsin Malik]

Thanks CJ, it worked

you also need to change pointer type longs from long to longlong or longptr