Third party call works in Excel VBA but not Access VBA

[yj0772]

I am using Windows 10, Office 2019 64 bit.

I am calling a function in a third party dll with :

Dim nreturn As Long

nReturn = XPRMinit

where XPRMinit is defined as :

Declare PtrSafe Function XPRMinit Lib "xprm_rt" () As Long

In Excel VBA, the code executes OK, but in Access VBA, I get a 'Run Time error '53' : File not found : xprm_rt message.

The xprm_rt.dll file is located in a folder defined in the Environment Path variable. I have tried :

1 copying it to Windows/System32

2 Registering it (it fails)

3 Adding it to VBA references (it wont)

all without success

and I can see XPRMinit in the Object browser.

Any ideas please ?

[vba_php]

is this you asking the question too?

https://answers.microsoft.com/en-us/...e-93d472a88ffb

it is verbatim.

yeah, but did you try to add it in the dir where the access EXE is actually at? not sure which one that is. diff versions have different dirs where they are put by ms. u see this?

https://answers.microsoft.com/en-us/...d-867d7f610916

did you reg it with regsvr32 ?

[yj0772]

Sorry, I did post it in the Microsoft forum and didn't action the 'multiposting' directive (I thought it was referring to multiple posts within the forum !).

I did try regsvr32 but the message back was that it couldn't register the dll.

HOWEVER, copying the dll to the access.exe location appears to work !!

How can Excel find a dll using the Environment Path variable, but not Access !!!

Anyway, thanks for your response