MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Anyone using Excel with a card reader?

  Asked By: Jody    Date: Oct 21    Category: MS Office    Views: 6172

I'm trying to develop a program utilizing input from a
card reader. I purchased an MSR216 and now I'm stuck.



4 Answers Found

Answer #1    Answered By: Estelle Pierce     Answered On: Oct 21

I've tried to input  data into excel  using a keyboard wedge and a barcode
reader. Excel does not seem to want to accept the output from this sort of
device. Excel especially rejected such ASCII generated things such as "TAB"

Answer #2    Answered By: Lori Wood     Answered On: Oct 21

I don't have any experience using card  readers with Excel, but I have interfaced
with various lab instruments. How does the card reader  interface with the

I suspect you will need VBA code to parse the data correctly into Excel. If
the device uses an RS232 serial interface, then I suspect you will need the
MSCOMM dll to do this, unless the card reader came with its own driver.

Do you have an online link for documentation? If so, I'd be glad to take a

Answer #3    Answered By: Sam Maxon     Answered On: Nov 12

Hi Estelle,

To input our Barcode reader USB directly to Excel we use the software Bill Redirect from the company BillProduction. First I setup my barcode scanner to USB COM PORT EMULATION (I read a barcode in the manual to do this) after I install the driver that come from my reader manufacturer ... After the software Bill Redirect take the control and you can add remove character on what your read. You can also with the free Excel Plugin call a VBA macro via DDE when a barcode is read. Usually we use Datalogic scanner that offer several possibility.

Didn't find what you were looking for? Find more on Anyone using Excel with a card reader? Or get search suggestion and latest updates.