Help : how can I specify the location of a DLL file in my Excel macro?

[hkharrytse]

Hi, I am a beginner in Excel Macro, trying the WINHLLAPI interface, planning to control QWS3270 from an Excel spreadsheet. I can successfully trigger the QWS3270 to open, and can get the data as displayed on the screen.

But when I run the following :
Call WinHLLAPI(nnn, sss, lll, ppp)

The system displayed the following error:

File not found : C:\program files (x86)\QWS3270 Secure\WHLLAPI.DLL

However, the WHLLAPI.DLL is indeed there in the above directory, and my Declare statement is as follows)

Public Declare Sub WinHLLAPI _
Lib "C:\Program Files (x86)\QWS3270 Secure\whllapi.dll" _
(ByRef f As Long _
, ByVal s As String _
, ByRef l As Long _
, ByRef r As Long)

What should the proper coding in the above Declare statement, or was my Call statement incorrect?

Can you help ? Much appreciated.