Possible to have BarCodes in Excel with no font or external DLL/App required?

**SWJeff** · 06-29-2010, 08:07 PM

Hello All,

Is it possible to have BarCodes (e.g. code128) in Excel with no font or external DLL/App required? I want to use a BarCode in a spreadsheet, but I can't expect all users to have a special font or DLL/app/ActiveX control installed.

I was thinking it might be possible for a VBA script to create a picture of the barcode and embed that in the spreadsheet. I can't pre-generate the barcodes, the end users will change the data in a cell.

Has someone done this? Is it possible? Where would I start?

--Jeff

**strokescribe** · 08-08-2010, 12:58 AM

Originally Posted by SWJeff

it might be possible for a VBA script to create a picture of the barcode and embed that in the spreadsheet
--Jeff

Try this:

Please Login or Register  to view this content.

It may be slow because each shape seems to be an OLE object. But you don't need to install addtitional software

PS More interestig way is to draw bars using WIN API and metafile. And then assign the metafile handle to Image object to display it. I think I can build a sample if you still need it.

Possible to have BarCodes in Excel with no font or external DLL/App required?

LinkBack

Thread Tools

Rate This Thread

Display

Possible to have BarCodes in Excel with no font or external DLL/App required?

Re: Possible to have BarCodes in Excel with no font or external DLL/App required?

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions