Code 128 & Excel

[Nat-Cat(Legacy Member)]

Hi, I receive lists of barcode numbers in Excel and need to convert them in bulk to use with the MRV Code 128aMA. Is there a formula I can use in Excel to do this? It would take a looong time to do using the Font Pal utility.

Thanks in advance, Cat

[glitch(Legacy Member)]

Cat,

Yes it is doable. You will need to import the module file first to your spreadsheet, and then calls Code128A or other functions.

You may take a look at our Excel sample.

To import th defintions of encoder functions, select Tools -> Macro -> Visual Basic Editor. When VB editor is open, select File -> Open. Navigate to the c:\program files\common files\morovia\moroviafonttools folder and select MoroviaFontTools.vbs. Close the VB editor and save the spreadsheet.

After you have the definitions of encoder functions, you can use them in your spreadsheet. For example, you can define cell C2 as

=Code128A(C$1)

Format C2 with our font you get the barcode in cell C2.

You can verify if the result is valid by comparing it with the one from FontPal.

More information can be found here: http://www.morovia.com/font/support/font-tool.asp

[Nat-Cat(Legacy Member)]

Thanks that's exactly what I require.

[043turning]

Hi Guys/Gals, Sorry my first post is a question but I am new to the barcode world and whilst I understand the need to handshaking Error corection and data integaty the software I'm using requires a "Tab"to be inserted at the end of the Data and Whilst I can find many ASCI table that show the code for functions like tab very few barcode generatos allow for the addition of special charators.
I guess my question is can you create a dta field like "19_SQR124-4L"and have a "TAB" included in the string using XLS =Code128A(C2)

Once again sorry for the first Post Question

[glitch]

See my answer at need-help-on-code128-and-excel-carriage-return-and-pipe--t221.html#p655

[043turning]

Thanks I did see it, and didn't realise that concatanation was possible, but I guess it's just an exteension to a formula, So why wouldn't it be... LOL