Opto 22

43044 Business Park Drive, Temecula, CA 92590 USA
Local & outside the USA:(951) 695-3000
Toll-Free within the USA:(800) 321-6786
Fax: (951) 695-3095
Email: sales@opto22.com

Using the SNAP PAC REST API with Excel

Filename: 2229_Using_SNAP_PAC_API_with_Excel.pdf
File Size: 6398 KB
Last Update: 8/24/2017


This document (included in OptoTutorial 2229) provides the instructions to create a Microsoft Excel® worksheet with Visual Basic® for Applications (VBA) macros that:
• Read and write to input and output points via the SNAP PAC REST API
• Parse JSON text strings
• Check for input and return errors
• Collect data on an automated interval and display it in an Excel chart

For more tips, help, and code samples, visit the Opto 22 Developer’s portal at http://developer.opto22.com.


The activities in the tutorial are based on the hardware and software that come with a SNAP PAC Learning Center (part number SNAP-PACLC).
If you don’t have a Learning Center but you’re comfortable using PAC Manager™ and PAC Control™, you can modify the instructions to work with your own Opto 22 devices.

You’ll need:
• Microsoft Excel 2007 (or higher) and a basic understanding of how to create, open, and close worksheets, select cells, and resize columns
• A SNAP PAC Learning Center (or your own SNAP PAC R- or S-series controller and I/O modules)
PAC Project™ Basic (included with the Learning Center and also available to download for free from the Opto 22 website) and a good understanding of PAC Manager and PAC Control
• The files in this tutorial’s download file


All Opto22

Request Information
  • FREE Product Brochure
  • Product Demonstration
  • PreSales Engineering Assistance

Opto 22 Product Support

Opto 22 Product Support is FREE Monday through Friday 7 a.m. to 5 p.m. Pacific Time

Product Support Numbers:

Local: (951) 695-3080
Toll-Free: (800) 835-6786
Fax: (951) 695-3017