+ Reply to Thread
Results 1 to 4 of 4

Barcode 39 generator with Macros

Hybrid View

  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    98

    Barcode 39 generator with Macros

    Hi there,

    I am looking for a Macro/Excel file that converts a series of numbers and letters into a code 39 barcode.

    I hope you can help me.

    Thanks in advance

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Barcode 39 generator with Macros

    so the way I have done this

    1) download the Code39 font
    2) format the cells using that font.

    once you have downloaded and registered the font it should show up in the standard font list.
    you can turn on the macro recorder and change a cell or two to the code39 font, then turn off the recorder and see the what the VBA Code should be...

    HTH

    that's pretty much it....
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    07-06-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    98

    Re: Barcode 39 generator with Macros

    Hi Ernest,

    I hoped to get a macro which creates the Code30 font and I do not have to dowbnload it. I am on a company computer and am not able to download add-ons.

    Any ideas?

    Cheers

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Barcode 39 generator with Macros

    understood...technically it's not an add-on, but I get your point....to that, nope, I don't know a way to draw the lines and such....sorry I couldn't help....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help with the macros on a invoice generator.
    By heinstransport in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-02-2015, 10:54 AM
  2. Barcode help
    By Potatoes and Onions in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2014, 11:49 AM
  3. [SOLVED] Macros Print multiple invoice Generator 2 different customers per single page Odd/Even num
    By Garbology in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-25-2013, 11:20 PM
  4. Replies: 1
    Last Post: 12-18-2011, 12:32 PM
  5. macros for read barcode digit and find
    By the_power in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2007, 11:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1