Search found 7 matches

by eqiom
Thu Mar 17, 2016 5:36 pm
Forum: VB and VBA (Excel, Access)
Topic: 2 PT-104 USB with 2 macro on a same computer
Replies: 2
Views: 14166

Re: 2 PT-104 USB with 2 macro on a same computer

Hello, Finally I solved the problem by avoiding using the "Sleep" function, which is blocking the excel spreatsheet and preventing opening or working with another excel file. The only way to be able to use excel while we are waiting between two measurement is to use the "Application.OnTime" function...
by eqiom
Wed Mar 09, 2016 6:08 pm
Forum: VB and VBA (Excel, Access)
Topic: 2 PT-104 USB with 2 macro on a same computer
Replies: 2
Views: 14166

2 PT-104 USB with 2 macro on a same computer

Hello Following some example and based on the advice from the previous topic, I made the following Excel spreatsheet to collect the data from the 2 PT-104 USB in a same file and in a same time (see attached file). Now on the same computer, I want to start an excel macro to collect the data from one ...
by eqiom
Tue Mar 08, 2016 6:45 am
Forum: VB and VBA (Excel, Access)
Topic: Two PT-104 USB on a same computer
Replies: 4
Views: 16376

Re: Two PT-104 USB on a same computer

Thank you a lot

Regards
by eqiom
Fri Mar 04, 2016 4:24 pm
Forum: VB and VBA (Excel, Access)
Topic: Two PT-104 USB on a same computer
Replies: 4
Views: 16376

Re: Two PT-104 USB on a same computer

Hello, I'm trying to use UsbPt104Enumerate to get the device information, so in the Function Declarations, I wrote: Declare PtrSafe Function UsbPt104Enumerate Lib "usbpt104.dll" (ByVal details As String, ByVal length As Integer, ByVal communicationType As Long) As Long and in the Sub GetData () I ha...
by eqiom
Thu Mar 03, 2016 6:02 pm
Forum: VB and VBA (Excel, Access)
Topic: Two PT-104 USB on a same computer
Replies: 4
Views: 16376

Two PT-104 USB on a same computer

Hello I'm running a computer with Windows Seven 64 bits and Excel 2016. I have 2 PT-104 USB : On the CQ493/053 I have four temperature measurement device On the CV669/077 I have two temperature measurement device With Picolog, I'm able to see the six measurement device Capture 3.JPG If I'm trying th...
by eqiom
Thu Mar 03, 2016 5:40 pm
Forum: VB and VBA (Excel, Access)
Topic: Cannot find UsbPt104.dll
Replies: 3
Views: 16747

Re: Cannot find UsbPt104.dll

Hello,

I followed your instructions, by installing the 64-bit PicoSDK 10.6.11 file and use the USBPT104_x64.xls (MS Excel VBA Example for USB PT-104 (64-bit)), and the problem was solved.

Thanks a lot
by eqiom
Wed Mar 02, 2016 3:48 pm
Forum: VB and VBA (Excel, Access)
Topic: Cannot find UsbPt104.dll
Replies: 3
Views: 16747

Cannot find UsbPt104.dll

Hello, I'm running a computer with Windows Seven 64 bits and Excel 2016. I have 2 PT-104 USB (CV669/077 & CQ493/053) running fine with Picolog. I'd like to control and do directly some data acquisition from excel. If I'm trying the file USBPT104.XLS, found in UsbPt104sdk10.5.0.11, I got an error mes...