Test and Measurement Forum

Excel data transfer

Post your VB and VBA discussions here

Excel data transfer

Postby bruceh » Mon May 19, 2014 3:39 am

Hi, I am trying to use ps4000.xls to log data from a Picoscope 4424
I have ps4000wrap.dll, ps4000.dll and picoIpp.dll installed in the win 64 system folder.
When I enable macros and hit "Get Data" there is a pause then I get a VB error:
Run-time error '49':
Bad DLL calling convention.

Debug shows the last of the 3 calls in the set trigger section
'Set trigger
Call ps4000SetTriggerChannelConditions(handle, triggerConditions, 1)
Call ps4000SetTriggerChannelDirections(handle, 2, 2, 0, 0, 0, 0)
Call SetTriggerProperties(handle, triggerChannelPropertiesArray(0), 1, 1, 1000)

Any ideas??

Posts: 0
Joined: Mon May 19, 2014 2:28 am

Re: Excel data transfer

Postby Hitesh » Mon May 19, 2014 12:56 pm

Hello Bruce,

If you are using version of the SDK, then the wrapper dll has been changed to incorporate new functions and also some existing functions have been changed where an input parameter is not used.

In this case, the auxEnable parameter is not used and has been removed from the function declaration.

Please modify the following lines of code in the example:

Code: Select all
'Declare Functions
Declare Function SetTriggerProperties Lib "ps4000Wrap.dll" (ByVal handle As Integer, triggerChannelPropertiesArray As Long, ByVal nProperties As Integer, ByVal autoTrig As Long) As Integer

'Calling SetTriggerProperties
Call SetTriggerProperties(handle, triggerChannelPropertiesArray(0), 1, 1000)

Note that the wrapper dll is now called ps4000Wrap.dll where the 'W' has been capitalised.

I hope this helps.

Technical Specialist
Pico Technology
Site Admin
Site Admin
Posts: 2032
Joined: Tue May 31, 2011 3:43 pm
Location: St. Neots, Cambridgeshire

Return to VB and VBA (Excel, Access)

Who is online

Users browsing this forum: No registered users and 0 guests