Barcode Software - SAP
License Terms (PDF)
Link To TEC-IT
There are two possible reasons why this size changing happens:
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 ideal solution would be to use the same readability options (screen font enlargement) on all involved PCs.
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 ideal solution would be to use the same screen resolution on all involved PCs.
Please note that in TBarCode Office V10.5.3 a workaround for this problem has been introduced. Beside that also Microsoft offers a workaround for this problem in KB838006.
To insert bar codes into a Microsoft Excel document please follow these steps:
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 multiple bar codes (list) with a single click.
For more videos visit our TBarCode Office Tutorial Channel!
TBarCode is inserted in Word as „Inline Shape“. In case of Inline Shapes, the shape is clipped if the line height is configured to a fixed value.
The barcode should be visible again if you adjust line spacing to "Single".
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.
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.
Please try the solution offered by the Microsoft Excel Support team here. If possible, avoid the remote desktop. In each case you should save the document before printing and not afterwards.
When opening a document or activating a worksheet, the focus is not on the last selected cell - instead Excel displays the (last) embedded Barcode ActiveX Control.
The following workaround moves the cursor back to actual selection. Press Ctrl-F11 to open the VBA editor and add the following code:
' Add to Module 1
Dim myRange As Range
Set myRange = Selection
' Add to Worksheet
Private Sub Worksheet_Activate()
' Add to Workbook
Private Sub Workbook_Open()
Save your document as Macro-enabled Workbook (XLSM).