Little_Clubber
New Member
- Joined
- Nov 10, 2017
- Messages
- 32
Hi Everyone,
Let's open with "I Love Excel!" It's great and so powerful as long as you tell it correctly what you want it to do. And that's where I need your help...
On a production line, we produce LH and RH parts, and apply a barcode label to each.
Barcode labelling of the parts is not the issue and this is always correct.
In months gone by however, we then put the LH part into the RH box (and vice versa), and sealed the box with parts missing (Quantity should be 72 but we have sent with 71 or less). Finally, if we get the correct quantity of the correct hand in the sealed box, we have then put the wrong label on the outside of that box.
I began writing a validation programme in VBA where the user scans the QR barcode into a userform.
The QR barcode contains 4 lines of text; this is split into 4 columns in the spreadsheet and the data checked (Correct hand) and quantity counted but if an incorrect part is scanned, I can get it to display an error but not carry on etc.
Is it possible to write the full programme in VB without the need for the spreadsheet as if there's any other user input required, it WILL go wrong. Specifically, I am looking to do this:
I'll have 2 tablets (1 on LH of workstation;1 on RH of workstation)<o
></o>
Part presented to tablet - with QR barcode<o></o>
1st scan will programme the tablet - From now on we're checking for this part<o></o>
Barcode contains 4 lines of text<o></o>
Part No<o></o>
Description <o></o>
Colour<o></o>
Unique Identifier
<o></o>
Then each following scan:
From part number - determine if partpresented to correct tablet (ie LH to LH)<o></o>
If not OK - error message (Actual Message TBD)<o></o>
If OK - confirm not previouslyscanned part (from unique identifier)<o></o>
If OK add 1 to the count<o></o>
At count of 24 display message"1st layer full"<o></o>
At count of 48 display message"2nd layer full"<o></o>
At count of 72 display "palletfull, present box label"<o></o>
Scan requested box label (this is a Code 39 barcode of the part number - so compare part numbers knowing that this is a pallet label because the entry was only a single line entry not a 4 line entry as per the barcode on each part)
<o></o>
If not OK - error message<o></o>
If OK - Green Tick and reset count to 0<o></o>
Any attempt to scan pallet labelbefore count of 72 - display error message
Thanks a million for any and all help.<o></o>
Let's open with "I Love Excel!" It's great and so powerful as long as you tell it correctly what you want it to do. And that's where I need your help...
On a production line, we produce LH and RH parts, and apply a barcode label to each.
Barcode labelling of the parts is not the issue and this is always correct.
In months gone by however, we then put the LH part into the RH box (and vice versa), and sealed the box with parts missing (Quantity should be 72 but we have sent with 71 or less). Finally, if we get the correct quantity of the correct hand in the sealed box, we have then put the wrong label on the outside of that box.
I began writing a validation programme in VBA where the user scans the QR barcode into a userform.
The QR barcode contains 4 lines of text; this is split into 4 columns in the spreadsheet and the data checked (Correct hand) and quantity counted but if an incorrect part is scanned, I can get it to display an error but not carry on etc.
Is it possible to write the full programme in VB without the need for the spreadsheet as if there's any other user input required, it WILL go wrong. Specifically, I am looking to do this:
I'll have 2 tablets (1 on LH of workstation;1 on RH of workstation)<o
></o>Part presented to tablet - with QR barcode<o
></o>1st scan will programme the tablet - From now on we're checking for this part<o
></o>Barcode contains 4 lines of text<o
></o>Part No<o
></o>Description <o
></o>Colour<o
></o>Unique Identifier
<o
></o>Then each following scan:
From part number - determine if partpresented to correct tablet (ie LH to LH)<o
></o>If not OK - error message (Actual Message TBD)<o
></o>If OK - confirm not previouslyscanned part (from unique identifier)<o
></o>If OK add 1 to the count<o
></o>At count of 24 display message"1st layer full"<o
></o>At count of 48 display message"2nd layer full"<o
></o>At count of 72 display "palletfull, present box label"<o
></o>Scan requested box label (this is a Code 39 barcode of the part number - so compare part numbers knowing that this is a pallet label because the entry was only a single line entry not a 4 line entry as per the barcode on each part)
<o
></o>If not OK - error message<o
></o>If OK - Green Tick and reset count to 0<o
></o>Any attempt to scan pallet labelbefore count of 72 - display error message
Thanks a million for any and all help.<o
></o>
