Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 2nd 17, 07:13 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2015
Posts: 4
Default bar code scanning w/spaces

I've been trying to figure this out for a while, played with it - gave up for a while, but now I need to figure this out.

In Excel 2007 using a Font called 3 of 9 Barcode, we have for years been using this successfully for part numbers or employee numbers which have only ever had single string of characters, i.e. ="*"&B5&"*". My problem is with our location labels. They have 3 levels of characters, i.e., WHSE B01 A05..

On our RF guns, we can type in by hand the location code we want (WHSE B01 A05) and our old Zebra 105SL printer prints the labels, no problem. The bar code which is printed by the Zebra, does not have any gaps (which I can tell) in the RF label, and the guns have no problems reading it.

I have tried various methods of separating the various components into separate cells, i.e., WHSE in E2, B01 into F2, A05 into G2 and then concatenating them back together but, our RF Guns won't read it.

But since we have 168 to do, I was hoping someone may have solved this in the past.

  #2   Report Post  
Old February 2nd 17, 08:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 763
Default bar code scanning w/spaces

I've been trying to figure this out for a while, played with it -
gave up for a while, but now I need to figure this out.

In Excel 2007 using a Font called 3 of 9 Barcode, we have for years
been using this successfully for part numbers or employee numbers
which have only ever had single string of characters, i.e.
="*"&B5&"*". My problem is with our location labels. They have 3
levels of characters, i.e., WHSE B01 A05.

On our RF guns, we can type in by hand the location code we want
(WHSE B01 A05) and our old Zebra 105SL printer prints the labels, no
problem. The bar code which is printed by the Zebra, does not have
any gaps (which I can tell) in the RF label, and the guns have no
problems reading it.

I have tried various methods of separating the various components
into separate cells, i.e., WHSE in E2, B01 into F2, A05 into G2 and
then concatenating them back together but, our RF Guns won't read it.

But since we have 168 to do, I was hoping someone may have solved
this in the past.


I thought the barcode software should convert spaces in the source text
to be included in the barcodes they generate; -the readers then can
rcognize the original source text 'as scanned'!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vba code runs...need spaces ........ Wanna Learn Excel Discussion (Misc queries) 2 January 20th 09 01:44 PM
Generating spaces in code ExcelMonkey Excel Programming 2 June 5th 08 07:49 PM
Auto Enter after scanning in a Bar Code David Setting up and Configuration of Excel 0 November 30th 07 04:34 AM
Bar Code Scanning Smileycam Excel Discussion (Misc queries) 1 July 5th 06 03:19 AM
Numeric code of spaces! Johan Excel Discussion (Misc queries) 1 March 6th 05 04:49 PM


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017