asked on

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

thanks,

csehz

ASKER

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?

ASKER CERTIFIED SOLUTION

VipulKadia

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

csehz

ASKER

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

thanks,