Excel won't register tab key presses when scan from a barcode made with Cabinet Vision

OK I don't know if this would be the right spot to post this but here we go.
I am currently using a program called Cabinet Vision and it able to mass produce barcodes. Great!
The barcodes can be made with TABs and any ASCII Code up to 128, however (unless I'm missing something),
when I try to scan them into Excel, it just records the information in a single cell. I've been talking with the tech gurus of the program
and they reckon it has something to with Excels layout. The command I use in CV is Chr$(9) which should translate into ASCII 9
which should be TAB. Also, when I scan into note pad the information tabs out properly and can be special pasted into excel that way.

Any help would greatly be appreciated. Thanks!