We help IT Professionals succeed at work.

How to embed barcode in excel using VB6.0? urgent!!!!!

CodingSucks
CodingSucks asked
on
Please help.

Thanks in Advance.
Comment
Watch Question

Senior .Net Consultant
BRONZE EXPERT
Top Expert 2016
Commented:
The easiest way is to use a Font like this free one: http://www.barcodesinc.com/free-barcode-font/

Just format a cell with this font and you will be done.

Author

Commented:
Hi Emoreau,

can you please explain in steps how can i use this font.

Thanks,
Na
Éric MoreauSenior .Net Consultant
BRONZE EXPERT
Top Expert 2016

Commented:
you know how to change the font of a cell? install the barcode font on your PC and use it

Author

Commented:
I installled font , how do i format cell . what i need to chose in format options in excel.
Éric MoreauSenior .Net Consultant
BRONZE EXPERT
Top Expert 2016

Commented:
select a cell, press CTRL-1, select the Font tab and find your font

Author

Commented:
i got it thanks.

Author

Commented:
emoreau

Barcode is not scannable. please see attachment.
Capture.PNG
Éric MoreauSenior .Net Consultant
BRONZE EXPERT
Top Expert 2016

Commented:
Did you surround your value with *?

from the web site:

Tips for Using the Barcode Font
•Be sure to add an asterisk * character before and after your text. Example *YOURTEXTHERE*

Author

Commented:
Yes .  I assigned value as following

ws.Range("A3").Value = "*N610-N4F2.2.5*"
Éric MoreauSenior .Net Consultant
BRONZE EXPERT
Top Expert 2016

Commented:
have you tried a simpler value like *N610* ?
how do you test your read?

Author

Commented:
yes i tried the value you suggested, unable to scan. My code just writes that value to Excel sheet cell.

Author

Commented:
right now i am using my Htc G2 to sacn the barcode , it did read the same value from different type of barcode from label printer
Éric MoreauSenior .Net Consultant
BRONZE EXPERT
Top Expert 2016

Commented:
try to find another font. you reader may have a problem with that font.

or try the font in word.

Author

Commented:
Barcode is scanning fine in excel 2010 , but in Excel 2003 it seems to be stretched . Any solution for this.
Éric MoreauSenior .Net Consultant
BRONZE EXPERT
Top Expert 2016

Commented:
can it be related to the font height or something like this? I don't have much ideas about this.

Author

Commented:
Ok . i will figure it out. Many thanks for your quick help.

naresh.

Author

Commented:
very simple and effective.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.