Test and Measurement Forum

unit not opened error

Post your VB and VBA discussions here

unit not opened error

Postby mayank.aron » Tue Apr 21, 2015 2:48 pm

Hello,

I am having trouble running the excel VBA script that came with the SDK. The function ps3000aOpenUnit always returns 0. I have 32 bit excel on a 64 bit system. I am running ps3000aV2. The dll's are in the syswow64 folder.

One theory, I do not have admin rights on my system. My user rights are Power User. Could this be limiting port access through the VBA script?
mayank.aron
Newbie
 
Posts: 0
Joined: Tue Apr 21, 2015 2:43 pm

Re: unit not opened error

Postby Martyn » Thu Apr 23, 2015 1:11 pm

That would be the correct return code if the call is successful, PICO_STATUS_OK, any other value would indicate an error.
Martyn
Technical Specialist
Martyn
Site Admin
Site Admin
 
Posts: 2280
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: unit not opened error

Postby F6AXK » Thu Nov 05, 2015 6:25 pm

Hello,

I have the same error message "Unit not opened" when running ps2000a.xls
My configuration Picoscope 2205A, PicoSDK 10.6.10.22, Windows 7 / 64 bits, Excel 2007 / 32 bits
The 3 necessary dll's are in the right place and I have checked that Picoscope 6 is not running when running Excel macro.
Function ps2000aOpenUnit returns handle=0 and so the error message appears.
How to solve this problem ?
F6AXK
Newbie
 
Posts: 0
Joined: Thu Nov 05, 2015 5:43 pm

Re: unit not opened error

Postby Martyn » Thu Nov 05, 2015 10:00 pm

You need to use the 2000 drivers and excel example, not the 2000a ones, even though you have a 2205a device.
Martyn
Technical Specialist
Martyn
Site Admin
Site Admin
 
Posts: 2280
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: unit not opened error

Postby F6AXK » Fri Nov 06, 2015 8:29 am

Thanks for useful reply. I had not noticed the need to use 2000 drivers instead of 2000a
I can now go further on.
F6AXK
Newbie
 
Posts: 0
Joined: Thu Nov 05, 2015 5:43 pm


Return to VB and VBA (Excel, Access)

Who is online

Users browsing this forum: No registered users and 0 guests