Get data from magnetic card reader to each cell
start with % , seperated by ^ and then end by ?
"NickHK" wrote:
Simon,
What are the groups of characters separated by ?
A space, multiple spaces ...
NickHK
"simon" wrote in message
...
Yes, it's a USB card reader simulates keyboard input into cell .
but it read into cell A1 only with all data at once
%BAS49247 ^STRONG/MORRI ^ E61158?
I need BAS49247 go to cell A1 with out %
STRONG / MORRI go to cell B1 without ^
and E61158 go to cell C1 without ^ and ?
at present time the cursor jump down to cell A2 and want to keep this way
thanks
"NickHK" wrote:
Simon,
Is this card reader is a keyboard wedge type ? Basically simulates
keyboard
input into the active control or cell ?
NickHK
"simon" wrote in message
...
Try to get data from magnetic card read into excel each cell
automatically
every time i scan the card
data read from megnetic card reader as following :
%BAS49247 ^STRONG/MORRI ^ E61158?
each time when card scanned BAS49247 go to column A with out %
STRONG / MORRI go to column B without ^ and E61158 go to column C
without
^ and ? And then cursor jump down to column A row 2
thanks
|