Test and Measurement Forum

usb DrDAQ signal generator in excel

Post your VB and VBA discussions here

usb DrDAQ signal generator in excel

Postby paul_Leslie » Fri Sep 16, 2011 3:37 pm

i'm trying to use the sig gen function in excel (its the only thing i have to program in) and cant get any kind of output, will this even work or am i missing something important from the code, the module is as follows

Declare Function UsbDrDaqOpenUnit Lib "USBDrDAQ.dll" (ByRef handle As Integer) As Long
Declare Function UsbDrDaqSetSigGenBuiltIn Lib "USBDrDAQ.dll" (ByVal handle As Integer, ByVal offsetVoltage As Long, ByVal pkToPk As Long, ByVal frequency As Long, ByVal waveType As Integer) As Integer

'(The above bits are both on one line each but this is how it copies and pastes)

______________________________________________________________________________
Sub Button11_Click()

Dim handle As Integer


Call UsbDrDaqOpenUnit(handle)
Call UsbDrDaqSetSigGenBuiltIn(handle, 0, 1000000, 440, 0)

End Sub

most of the sig gen function was taken from some code using a different scope with some other variables and i dont know if the waveType is either diclared or used the same

and help would be much appreciated
paul_Leslie
Newbie
 
Posts: 0
Joined: Fri Sep 16, 2011 12:58 pm

Re: usb DrDAQ signal generator in excel

Postby Hitesh » Mon Sep 19, 2011 10:04 am

Hi Paul,

The signal generator function should work.

Looking at the Programmer's Guide (see p26 - 3.5.17 UsbDrDaqSetSigGenBuiltIn), I would suggest that the line matches the input types for frequency - it needs to be a 2-bit number:

Declare Function UsbDrDaqSetSigGenBuiltIn Lib "USBDrDAQ.dll" (ByVal handle As Integer, ByVal offsetVoltage As Long, ByVal pkToPk As Long, ByVal frequency As Integer, ByVal waveType As Integer) As Integer

Have you tested the device in PicoScope to check if the signal generator itself is working?

If you need further assistance, please e-mail your source code file to support@picotech.com.

Regards,
Hitesh

Technical Specialist
Pico Technology
Hitesh
Site Admin
Site Admin
 
Posts: 2008
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