Test and Measurement Forum


Post your VB and VBA discussions here


Postby whiskeymack » Tue Nov 25, 2014 11:57 am

I am trying to use the excel example in the PS3000Askd folder. I am using Excel 2010 with Windows 7. on a 64bit PC.
I have run the DPInst.exe program and loaded the PS3000a.dll and ps3000awrap.dll into windows/system32 folder.

When I try to run spreadsheet and press the Get Block button a progress bar window comes up, the driver version info etc is displayed then the program crashes with an error box saying it cannot find ps3000awrap.dll.

There are two versions of ps3000awrap.dll. in Wrapper/Release/ which one should I be useing (I have tried both), where should I put it..

Any other ideas??
Posts: 0
Joined: Thu Nov 20, 2014 2:08 pm

Re: ps3000awrap.dll

Postby AndrewA » Mon Dec 01, 2014 12:10 pm

Hi Whiskeymack,

Do you have 32 or 64 bit version of office installed?
To find this In excel -click on the File menu tab - then click Help - look in the right hand pane under About Microsoft Excel.
I have made a zip file with a full 32 and 64 bit Excel examples, can you email support@picotech.com
And I will send these to you. These will be added to a future SDK package.

If your version of Excel 2010 is 64 bit-
(You have to add PtrSafe after Declare key word of the function) Eg

Code: Select all
Declare PtrSafe Function ps5000aOpenUnit Lib "ps5000a.dll" (ByRef handle As Integer, ByVal serial As String, ByVal Resolution As Long) As Long

Please copy the supplied dll’s into your \Windows\system32\ folder, before running the example.

If your version of Excel 2010 is 32 bit on Windows 64 bit-
Please copy the supplied dll’s into your \Windows\SysWoW64\ folder, before running the example.

Regards Andrew
Technical Specialist
Last edited by AndrewA on Mon Dec 01, 2014 2:14 pm, edited 4 times in total.
Reason: added 32 bit text
Regards Andrew
Technical Specialist
Zen Master
Zen Master
Posts: 178
Joined: Tue Oct 21, 2014 3:07 pm

Return to VB and VBA (Excel, Access)

Who is online

Users browsing this forum: No registered users and 0 guests