CED Magic Excel Macro

CED Title Excel Macro

This is a macro for the Microsoft Excel spreadsheet application, that reads a list of CED universal product codes (UPC's) entered into column A, and returns a worksheet listing the title names corresponding to those UPC's. Nearly all CED titles have a UPC on the upper left corner on the back of the caddy. There are two ways to get these UPC's into Excel. The easiest way is to use a handheld laser scanner like the one in the photo to directly scan the UPC's into a computer running Excel. The scanner shown is powered by the notebook computer, but others run on batteries and allow the UPC's to be uploaded to the computer at a later time. The CueCat Scanner was once given away for free and plugs into the PS/2 keyboard port or USB port and makes UPC scanning possible with auxiliary software. Another method is to simply type the numbers printed under the UPC's into each successive cell in column A. This is a tedious process, but is still a lot easier than typing the names of the titles, and it's made considerably easier if one person reads off the number while another types.

There are two versions of the macro CEDMAGIC.XLM. One accepts 11-digit UPC's, while the other accepts 10-digit UPC's. Most scanners are programmed to read the 11th checksum digit, so use this version with a scanner. If typing by hand, use the 10-digit version, since only 10 digits are visible under the UPC bar code. There are versions of the macro compatible with Microsoft Windows (including Windows 3.x/95/98/NT/2000/ME/XP/Vista/7/8) and the Macintosh. This macro is written in the Excel 4.0 macro language, which is forwards compatible with all later versions of Excel.

Locate an inexpensive CueCat by searching for ("cue cat",cuecat) at the eBay auction site.
Detailed instructions on using the CueCat optical reader for UPC scanning.

Download cedmag11.zip for 11-digit UPC's and Excel for Windows

Download cedmag10.zip for 10-digit UPC's and Excel for Windows

Download cedmagic.xlm-11.sit.hqx for 11-digit UPC's and Excel for the MacOS

Download cedmagic.xlm-10.sit.hqx for 10-digit UPC's and Excel for the MacOS

Home