Try splitting each record into an array
Dim MyArray() As String
'*
MyArray = Split(record, "|")
For i = 0 To UBound(MyArray)
'any code working with each field in the array
'including using the first field as the tab name
Next i
hope this helps!
Another method, although not entirely fool proof is that you allow the scanners to send the start/stop characters of the bar code.
This isn't usually "seen" in the eye readable format, so when the user types the barcode it will be without the start/stop characters.
This is how I've set it up -...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.