This technical note describes how to read from and write to an Opto 22 SNAP PAC programmable automation controller via the PAC’s RESTful API, using Visual Basic for Applications (VBA) with Microsoft Excel. In this way you can securely share I/O point and variable data in your SNAP PAC controller with an Excel spreadsheet.
This tech note accompanies the sample spreadsheets in the SNAP PAC RESTful API to Excel Spreadsheet Example. Also, see the SNAP PAC RESTful API to Excel video.
Download