Easily generate barcodes in Excel for Mac with IDAutomation's AppleScript files and Universal font. When data needs to be encoded in a barcode, the script will format the data and return a character string that will create an accurate barcode when combined with the appropriate Universal Font.
This tutorial is designed to guide Mac users implementing AppleScript within Excel for Mac 2004 and 2008. As a reference, two files included in the Universal Barcode Font Package, AppleScript_Excel_Example.xls and the AppleScript_Excel_Example_IDAutomation128b.scpt file can be used as a guide. Available in the licensed version only.
--Run handler showing communication with Excel on run tell application "Microsoft Excel" tell sheet "Sheet1" of workbook 1 set EndofRow to 3 -- This defines the last Excel Row with data; it this example, it is A3. set input_data to "" repeat with i from 1 to EndofRow -- This loop will run from row 1 until EndofRow set above. For this example, it was set to 3. set InputCell to the value of (cell i of range ("A1:A" & i)) -- This line defines the range, where in this example it is set A1:A3 and i is the counter and will continue to loop until EndofRow. set input_data to InputCell set encoded_data to IDAutomation_Uni_C128b(input_data) of me set EncodedCell to ("B" & i) -- This is where to designate where the encoded data is to appear. In this example, the encoded data will be in Column "B". set value of cell EncodedCell to encoded_data end repeat end tell end tell end run --End of Excel Code
| ©Copyright 2018
IDAutomation.com, All Rights Reserved.
Barcode Fonts | Components | Scanners | Support | Contact Us
Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses.