• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

Bar code transfer to Excel

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

  • 2
1 Solution
csehzIT consultantAuthor Commented:
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?
You can use 'TextToColumns' functionality of Excel. And give '*' as a delimiter.
csehzIT consultantAuthor Commented:
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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now