Bar code transfer to Excel

Posted on 2011-10-18
Last Modified: 2012-06-21
Dear Experts,

We have a scanner which works like this

1) scanning on a printed label
2) it is writing data to Excel cell A, concretely this string 10000819**1000**52*stck*stx*xa11a**

Could you please advise is it possible maybe done in VBA code, that at each "*" character the excel cell selection should jump a tab right?

Practically we would like to program this below steps, but briefly it means just go one tab right at each "*"

-      Enter 10000819 to cell B2
-      Seeing the * that should mean tab so go to C2
-      Seeing the * that should tab so go to D2
-      Enter 1000 to D2
-      Seeing the * that should tab so go to E2
-      Seeing the * that should tab so go to F2
-      Enter 52 to F2
-      Seeing the * that should tab so go to H2
-      Enter stck to H2
-      Seeing the * that should tab so go to I2
-      Enter stx to I2
-      Seeing the * that should tab so go to J2
-      Enter xa11a to I2
-      Seeing the * that should tab so go to K2
-      Seeing the * that should tab so go to L2

Question by:csehz
    LVL 1

    Author Comment

    Basically I think maybe it is not a scanner question, maybe we should configure the Excel simply that if someone enter "*" on the keyboard, that should mean Tab?

    Is it possible such key short-cut?
    LVL 8

    Accepted Solution

    You can use 'TextToColumns' functionality of Excel. And give '*' as a delimiter.
    LVL 1

    Author Comment

    That sounds a super idea, I have tested and seems okay.

    Maybe I will come with such question yet but for me this is solution and will try to apply this


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now