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

LJM Examples Where Is An Example To Do XYZ Minimal (Referencable)

Communication Basics

With the LJM library, pretty much everything you might want to do with a device is accomplished by writing and/or reading some registers. Look at the device's datasheet (T7 or T4) or the Modbus Map to determine what registers you need to write and read, then use eWriteName (or eWriteNames) to write the desired registers and eReadName (or eReadNames) to read the desired registers.

LJM Visual Basic/VB6/VBA Wrapper/Examples Bottom (Referencable)

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

Ljackuwx.ocx missing

I have downloaded and installed LJM Library and the VBA examples but cannot find the ocx file anywhere!?

Submitted by LabJack Support on Fri, 04/29/2016 - 11:45

The active-x component

The active-x component ljackuwx.ocx is for the U12 and is not used by the LJM VB examples.

Datasheets and User Guides

App Notes

FAQ

Quickstart Guides

Software & Driver

Firmware

User menu

Shopping cart

LabJack will be closed Monday, May 30th for Memorial Day.

Visual Basic, VB6, VBA for LJM - Windows

LJM Visual Basic/VB6/VBA Wrapper/Examples (Software Platform)

VBA_LJM_2017_03_06.zip

VBA_LJM_2014_07_28.zip