Questions? Search our site or call us at 1-800-722-6004

Merge Barcode (B-Coder and Word)

The following is a subroutine for Word 97/2000 that searches through a document looking for any text with the style "barcode". If it finds any, it converts the text to a barcode.

Sub MergeBarCodes()
  'run B-Coder Minimized
  Shell "C:\B-CODER3\B-CODER.EXE", 6
  ' Note: make sure that the path for B-Coder is correct in the above command
  
  ' open DDE channel to B-Coder
  Chan = DDEInitiate("B-Coder", "System") 
  
  ' initialize B-Coder here- send dde commands to set up Bar Codes
  ' DDEExecute Chan, "[Code128]" ' tell B-Coder to use Code 128
  ' DDEExecute Chan, "[messagewarnings=off]" ' turn off warning messages
  ' DDEExecute Chan, "[printwarnings=off]"
  ' DDEExecute Chan, "[height=.5]" ' set bar code height
  
  On Error GoTo bye ' quit if an error occurs
  Set MyRange = Selection ' define a range object
  MyRange.SetRange Start:=ActiveDocument.Content.Start, _
    End:=ActiveDocument.Content.End
  
  ' set the range to start at the top of the document and end at the bottom
  While 1 = 1 ' loop forever
  With MyRange.Find ' set Find object properties
    .Forward = True  ' search forward
    .Wrap = wdFindStop  ' stop at end of document
    .Style = "barcode"  ' look for style "barcode"
    .Execute ' do it now
  End With
  
  If MyRange.Find.Found = False Then GoTo bye ' quit if style not found
  
  BCData$ = Selection.Text ' otherwise get bar code data
  
  If Right$(BCData$, 1) = Chr$(13) Then
  ' Remove the carriage return at the end of the selected text
    BCData$ = Left$(BCData$, Len(BCData$) - 1)
  End If
  
  'Create the bar code
  DDEExecute Chan, "[BARCODE=" + BCData$ + "]"

  ' Selection.MoveDown Unit:=wdLine, Count:=1, Extend:=wdMove
  ' to put the bar code on the line below the text, un-comment the above line
  
  MyRange.PasteSpecial DataType:=wdPasteMetafilePicture, Placement:=wdInLine
  ' paste in the bar code
  Wend ' go find the next one

bye:
  On Error GoTo 0 ' remove error trap
  
  ' tell B-Coder to quit
  DDEExecute Chan, "[Appexit]" 
End Sub

Categories: Macro / Code Sample, Microsoft Word, Barcode Generation, Standalone Desktop Application, B-Coder

Last Updated: 2013.08.30

Need more help?

Don't hesitate to call or email us with your questions

Our office is open 9AM - 5PM Monday Through Friday (E.S.T.)

Technical Support: 215-496-0202

Toll-Free: 1 (800) 722-6004
Skype: taltech1 (Voice only)
Email: support@TALtech.com