Bar codes

[bob]

First let me tell you what I want to accomplish.
I am creating a form that, when used, a part will perferated and stay
in one department (parts) and the rest will stay with the originator.
The parts department will then return that portion of the form with
the part to the originator to match up with main form.
The requirement is that we use a bar code on both portions of the
form. They need to be the same number but from sheet to sheet they
need to be sequentialy higher.
Such as, the first sheet is 10000 the next 10001... useing the bar
code format.
The form could be preprinted except for the bar code area, for the bar
code I wanted to print as variable data to the form. It would appear
twice on each form. We use Elfring's BAR39 for creating bar codes.
Any ideas on how this could be accomplished.

 

[JE McGimpsey]

The form could be preprinted except for the bar code area, for the bar
code I wanted to print as variable data to the form. It would appear
twice on each form. We use Elfring's BAR39 for creating bar codes.
Any ideas on how this could be accomplished.

I didn't realize Elfring's BAR39 utility ran on Macintosh. I've no idea
how to hook it into MacXL. In WinXL, one can use VBA hooks...

Do you have a URL to the utility? Is it AppleScript-savvy?

 

[macropod]

Hi Jim,

The Code 3of9 system doesn't require any conversion code - it's a 1:1 character representation of a normal upper-case font, usually
with asterisks as the start/end characters. Sometimes a mod43 check character is added, but that's just a simple lookup. See:
http://idautomation.com/code39faq.html

Cheers

 

[JE McGimpsey]

The Code 3of9 system doesn't require any conversion code - it's a 1:1
character representation of a normal upper-case font, usually
with asterisks as the start/end characters. Sometimes a mod43 check character
is added, but that's just a simple lookup. See:
http://idautomation.com/code39faq.html

When the OP wrote "We use Elfring's BAR39 for creating bar codes", I
interpreted that as meaning Elfring's stand-alone BAR39 Utility:

http://www.elfring.com/bar39-u.htm

which I've used on PCs before. I'm not aware that they make a Mac
version.

If all the OP meant was that they're using a code39 font, then all
that's needed is to generate the sequential numbers. This may help:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html