How To Set Up A Barcode Scanner With Excel For Mac



Read below to learn how to pair a CS4070 Bluetooth scanner to your Windows or Macintosh computer. You can use a barcode scanner to manage your vaccine inventory in PCC EHR.

For information on how to use immunization barcodes with PCC EHR, read the Use a Barcode Scanner to Manage Immunization Lot Inventory article.

Then follow the instructions here to set up your computer for network scanning using the Epson Scan 2 Utility. Your scanner must be turned on and connected to the network. Note: Make a note of the IP address or host name of the scanner or the optional Epson Network Interface Unit so you can enter it in these steps. What I need to know is how do I set up this scanner to read the barcodes off of the POLYCOM boxes and translate them into the mac address's for the phones and post the data into the CSV sheet I've created. Keep in mind, I have not even plugged the scanner into a pc at this point; it is fresh out of it's box. The Network Path is the Mac's IP address followed by the name of the shared folder on your Mac. To find your Mac's IP address, click the Apple icon, click System Preferences, and then click Network. The IP address displays next to Status.

How to set up a barcode scanner with excel for mac download

How to Use a Barcode Scanner with Excel You can use barcode scanners with Excel to scan existing barcodes and enter the data into Excel. For example, when a shipping/receiving department gets new parts, they can scan the barcodes on each part and then enter those codes into a Received Parts spreadsheet. How to scan barcodes into Microsoft Excel. You can create a real-time link between a sheet in Orca Scan and Microsoft Excel from the web application. Data collected by users with the Orca Scan mobile app will then be pushed directly into your Excel sheets from anywhere in the world.

Pair With A Single Workstation: Because of the way bluetooth works, a scanner can only pair with one computer at a time. Swapping bluetooth scanners from one laptop to another is a complicated and time-consuming process. If you use bluetooth scanners, you will need one scanner per computer.

Manual Available Online: A CS4070 scanner comes with a Quick Reference Guide, but you may find you want more in-depth information about how to use the CS4070. The manual is available online from the manufacturer.

Barcode generator

Contents

Instructions for Windows

Open “Bluetooth and other device settings”

Put the Scanner in Discovery Mode

Hold the Bluetooth button on the scanner until it beeps. It is now in discovery mode and ready to pair. If you do not pair the scanner within two minutes, it will beep again and turn off Bluetooth. If this happens, simply hold the Bluetooth button again to re-activate discovery mode.

Search for Bluetooth Devices with your Computer

Select the CS4070

You will see any number of Bluetooth-enabled devices in this list. Some you may recognize, some you may not. Any device within range will appear, which can include Fitbits, wireless mice and keyboards, phones, and other electronics. Select the CS4070. Your computer may recognize it by name, or it may simply recognize it as a “Keyboard”.

Scan the PIN

Barcode Scanner App

Your computer will ask you for a PIN number. Use the scanner to scan the barcodes that correspond to the numbers on pages 10 and 11 of the Quick Reference Guide that came with your scanner (or pages C-9 and C-10 of the online manual). Remember to scan the “Enter” barcode at the end.

Scanner

Your scanner is now paired with your PC, and will work with PCC EHR.

Set

How To Set Up A Barcode Scanner With Excel For Mac Pro

Instructions for Mac

Open Bluetooth Settings

Use the Apple menu to open System Preferences, and then click on the Bluetooth icon.

Turn Bluetooth On

Put the Scanner in Discovery Mode

Hold the Bluetooth button on the scanner until it beeps. It is now in discovery mode and ready to pair. If you do not pair the scanner within two minutes, it will beep again and turn off Bluetooth. If this happens, simply hold the Bluetooth button again to re-activate discovery mode.

Pair the CS4070

You will see any number of Bluetooth-enabled devices to pair. Some you may recognize, some you may not. Any device within range will appear, which can include Fitbits, wireless mice and keyboards, phones, and other electronics. Select the CS4070. Your computer may recognize it by name, or it may simply recognize it as a “Keyboard”.

Your scanner is now paired with your PC, and will work with PCC EHR.

Unpairing a Scanner

Bluetooth devices can only be paired with one computer at a time. If you need to pair a scanner with a new computer, you will need to unpair it from the original workstation. Simply go to your list of Bluetooth devices, right click on the CS4070, and click “uninstall”.

PCC 8.3 Migration Considerations

How To Set Up A Barcode Scanner With Excel For Mac Download

ExcelPCC 8.3 Release Video