Bar Code Scanner Integration

Hello all,

I am looking to integrate a basic numerical bar code scanner into excel. The Reader just scans a card and prints the numbers as plain text like a keyboard. Im looking to format a table so that it can log the date and time that the card was scanned and store it in a list. i also need it to compare the time it was scanned to a preset time (the day they last renewed their monthly to see if it is expired and give a notification if the card is expired.

I assume ill i would need is a coulomb to list all the times and dates and once it reaches past one moth (the time it takes the card to expire) it will give a notification.

What is the best way to go about this are there third party applications that could do this in a more simple way.

Thank you!