Test and Measurement Forum

USB DrDAQ NOT OPENED ERROR

Post your VB and VBA discussions here

USB DrDAQ NOT OPENED ERROR

Postby Glovisol » Tue Dec 08, 2015 4:51 pm

I am unable to make the Excel file for collecting DrDAQ data in the SDK work at all. As soon as I hit the GET DATA button the NOT OPENED error message comes up.....

I removed the "DrDAQ open" check from the Macro, but still no dice. It look like Excel is unable to link to Picolog.

O.S. Windows XP
Excel 2003

Any suggestion?

glovisol
Glovisol
Advanced User
Advanced User
 
Posts: 114
Joined: Sat May 11, 2013 10:03 am
Location: San Marzano Oliveto, Asti, Italy

Re: USB DrDAQ NOT OPENED ERROR

Postby Hitesh » Wed Dec 09, 2015 10:14 am

Hi Glovisol,

If the PicoLog software is open and connected to the device, please close it and then try to connect to the device again.

Are you using the example and drivers from the latest SDK release?

Regards,
Hitesh

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

Re: USB DrDAQ NOT OPENED ERROR

Postby Glovisol » Wed Dec 09, 2015 1:39 pm

Hi, Hitesh,

I downloaded the SDK yesterday, so it should be up to date. When the Excel file opens I see:

The "Get Data" pushbutton in L3.

"Unit opened" in L10

"USB DeDAQ in L11

Serial number:" in L12 and: "AO819/039" in M12

"Driver version:" in L13 and: "1.0.0.163" in M13

This must be data stored in the file when you last closed it (I saw it was written by Robin and last changed by you personally). On the other hand the serial no. of my DrDAQ is: CY380/108.

I tried to first open the Excel file and then Picolog. Then I tried to do the reverse. I tried with Window XP. Then I tried with Windows 7 on DIFFERENT PC's, but it never worked. As far as I can see a link between Excel and Picolog is missing. This other file I am enclosing is very rugged and works very well, but it is not what I need. I enclose both.

It now comes to my mind: must the Excel file be in the Picolog directory?

Kind regards,

G. Lovisol

Generic DrDAQ display.xls
(35 KiB) Downloaded 36 times


TEST DrDAQ.xls
(41 KiB) Downloaded 36 times
Glovisol
Advanced User
Advanced User
 
Posts: 114
Joined: Sat May 11, 2013 10:03 am
Location: San Marzano Oliveto, Asti, Italy

Re: USB DrDAQ NOT OPENED ERROR

Postby Glovisol » Wed Dec 09, 2015 1:51 pm

Hi Hitesh,

I even tried to put the file into the Pico Full Directory, but to no avail..

Best regards,

glovisol
Glovisol
Advanced User
Advanced User
 
Posts: 114
Joined: Sat May 11, 2013 10:03 am
Location: San Marzano Oliveto, Asti, Italy

Re: USB DrDAQ NOT OPENED ERROR

Postby Hitesh » Thu Dec 10, 2015 12:59 pm

Hi glovisol,

If you are calling the API functions directly, then the drivers must be located on a path specified in the Windows PATH Environment Variable which the MS Excel VBA macro can then locate. You should then be able to place the Excel file in a location in your (My) Documents folder.

If you have installed the SDK using the installer, then the path to the dlls will be added to the PATH Environment Variable.

I have attached a couple of updated SDK examples that you can try - one is an xls file, the other an xlsm file.

USBDRDAQ.xls
USB DrDAQ Example xls file
(42.5 KiB) Downloaded 37 times

USBDrDAQ.xlsm
USB DrDAQ Example xlsm file
(29.02 KiB) Downloaded 33 times


If the device is is use by another application, then the VBA code cannot connect to it. Please check to see if any plw32.exe processes are running on the PC at the time when you try to run the Excel test example.

If you are using Dynamic Data Exchange (DDE) then you can use this when PicoLog is running and connected to the device.

I hope this helps.
Hitesh

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

Re: USB DrDAQ NOT OPENED ERROR

Postby Glovisol » Fri Dec 11, 2015 9:27 am

Dear Hitesh,

Thanks for the explanation & new files. DrDAQ is busy now, but I shall test new files over the weekend.

Kind regards,

glovisol
Glovisol
Advanced User
Advanced User
 
Posts: 114
Joined: Sat May 11, 2013 10:03 am
Location: San Marzano Oliveto, Asti, Italy

Re: USB DrDAQ NOT OPENED ERROR

Postby Glovisol » Tue Dec 15, 2015 7:49 pm

Dear Hitesh,

Thank you for your help! It works now. I am going to write DETAILED INSTRUCTIONS in the DrDAQ Section to make it easier for everybody.

Kind regards,

glovisol
Glovisol
Advanced User
Advanced User
 
Posts: 114
Joined: Sat May 11, 2013 10:03 am
Location: San Marzano Oliveto, Asti, Italy


Return to VB and VBA (Excel, Access)

Who is online

Users browsing this forum: No registered users and 0 guests