Note to VBA Users: The VB6 example demonstrates additional LJM usage. VB6 code can be used in VBA, so take a look at the VB6 example as well. The VB6 example's .frm file contains the source code and can be opened in any text editor.

Prerequisites

LabJack T7 or T4
LJM Library - Install the LJM Library
Applications that support VBA (such as Excel), or Visual Basic 6
Operating system - Windows

File list

VBA_LJM_2017_03_06.zip contains:

LabJackM_VB.bas
LJM_VB6_eFunctions\LJM_VB6_eFunctions.frm
LJM_VB6_eFunctions\LJM_VB6_eFunctions.frx
LJM_VB6_eFunctions\LJM_VB6_eFunctions.vbp
LJM_VBA_eFunctions\LJM_VBA_eFunctions.xls
LJM_VBA_SimpleStream\LJM_VBA_SimpleStream.xls

7 comments

Submitted by Erol (not verified) on Sat, 02/22/2014 - 21:41

T7-Pro OEM version. Is it

T7-Pro OEM version.

Is it possible to send and receive data from the board under vb6 used as GUI?

from VB6 GUI sending cmd like mscomm.output a,123 data...

how it is done in vb6 to send similar data in wifi, Eternet?

Erol

Submitted by LabJack Support (not verified) on Mon, 02/24/2014 - 09:45

Yes, It is possible to send

Yes, It is possible to send and receive data from the board in VB6. First open the device using the OpenS() or Open() functions, then use the handle to write or read values from the device. The open call is very similar for WiFi, Ethernet and USB, simply use OpenS(T7, WiFi, ANY), or OpenS(T7, Ethernet, ANY), or OpenS(T7, USB, ANY). See LJM_OpenS for more details on the open call.

Submitted by TVGemert (not verified) on Mon, 03/24/2014 - 14:05

Have you thought of making it

Have you thought of making it a com object that can call its own memory and thread. This would allow for use in Dot Net and C# J# VB C++ calls with out much trouble in coding. Since VBA is nice to use inside excel spread sheets but would be more use full to attach to web services or other custom services. If the peek poke driver was built in a COM object interface the porting would be more easier to all application models.

Just wondering?

Submitted by jmanjarresc3 (not verified) on Thu, 06/05/2014 - 13:35

With simple VBA example done

With simple VBA example done in Excel 2000, when I run it I got 1298 LJME_ATTR_LOAD_COMM_FAILURE. Running in excel 2013

Submitted by LabJack Support (not verified) on Thu, 06/05/2014 - 13:57

Usually that error occurs

Usually that error occurs when you are trying to open an unsupported device in the LJM driver. The LJM driver, which this example uses, only supports the T7 and Digit currently. If you are using a UE9, U6 or U3, use the examples from here:

http://labjack.com/support/ud/examples/visual-basic

If you are using a T7 and are getting this error, can you tell us the connection type you are trying to use (Any, USB, Ethernet, TCP, or WiFi). If you didn't modify the example's VBA code the connection type is Any.

Submitted by Keith Morton on Mon, 04/25/2016 - 19:23