Create QR-Code!

FAQ: TBarCode Office Excel Add-In

Frequently asked questions about TBarCode Office Barcode Add-In for Excel.

 

Excel

Barcode Size Changes On Different PC

There are two possible reasons why this size changing happens:

1. Enlarged Screen Fonts

User A is using standard font sizes (100%). User B has adjusted enlarged screen fonts (e.g. 125%). User A saves the Excel sheet with the bar codes in normal (correct) size. User B opens the sheet and discovers the bar code object with a different size (scaled according to the difference in screen font sizes).

Excel scales the bar code objects independently from TBarCode Office. The only solution would be to use the same readability options (screen font enlargement) on all involved PCs.

2. Different Screen Resolution

User A has a screen resolution of 1280x1024 Pixels. User B has a screen resolution of 1600 x 1200 Pixels. User A saves the Excel sheet with a bar code in normal (correct) size. User B opens the sheet and discovers the bar code object with a different size (scaled according to the difference in screen resolution between A and B).

Excel scales the bar code objects independently from TBarCode Office. The only solution would be to use the same screen resolution on all involved PCs.

Insert Barcodes

Inserting a Single Barcode into Microsoft Excel

To insert bar codes into a Microsoft Excel document please follow these steps:

  1. Switch to the Add-Ins tab.
  2. Open the TBarCode Panel.
  3. Position the mouse cursor in a cell.
  4. Select the barcode type (e.g. Code 128).
  5. Enter the barcode data or use the default data for the selected barcode.
  6. Adjust the size of the barcode (width, height, module width etc).
  7. Click the button Insert Barcode. Finished!
Insert Barcodes into Microsoft Excel with TBarCode Office

Insert Barcode Lists

How to Create a Barcode List

  1. Open the Excel spreadsheet with the barcode data (e.g. a list with article numbers) or create your own list.
  2. Open the TBarCode Panel.
  3. Mark the cells with the barcode data.
  4. Select the barcode type (e.g. Code 128).
  5. Click the button Insert Barcode. Finished!
Excel Add-In: Create a List with Barcodes

TBarCode Office Video

Single Barcodes

Barcode Lists

Video: Creating Barcodes and Barcode Lists in Excel

The first part of the video demonstrates how to create a single barcode. If required the barcode can be linked to a spreadsheet cell. Dynamic bar-codes, which are updated automatically, are implemented easily with this cell linking feature. In the second part of the video you learn how to create bar-code lists with a single click.

For more videos visit our TBarCode Office Tutorial Channel!

Security Settings

Barcode Control Blocked or Barcode Not Updated

Please verify your security settings.

Network Path

By default documents from a shared network path containing active content (such as barcode controls) are opened in a safe mode, where active content may be disabled. If you see a yellow security warning on top of your document, go to the trust center in Word and/or Excel and allow the network path you use.

Security Alerts

TBarCode Office is using ActiveX Controls for bar code creation. Depending on your security settings, ActiveX Controls may be blocked. If you see a yellow security warning on top of your document, you have to click "Enable Content" to allow access to the Barcode ActiveX Controls. The behavior of ActiveX Contols can be adjusted as shown below:

Excel

Print Preview or Printing Changes the Barcode Position

Problem

The following problem has been encountered: With Remote Desktop connections and Terminal Server sessions the bar code position changes after opening the print preview or printing the document. Over time the bar codes shift slightly towards the top left or bottom right, causing the bar codes to wander.

Reason

The reason may be a program error of Excel. The position of the bar code controls is managed by Excel independently - the add-in has no influence on that (except during insert). The usage of the remote desktop probably triggers the problem.

Solution

Unfortunately we cannot offer a workaround for this problem. If possible, avoid the remote desktop. In each case you should save the document before printing and not afterwards.

© TEC-IT Datenverarbeitung GmbH, Austria  |  Site Map  |  RSS  |  Imprint  |  Legal Conditions and Privacy  |  Contact