Browse FAQs

How to use Microsoft Excel to connect to OFS V3.31.

Published date: 10 June 2020

Release Notice

This is only an example and is not supported or make any claims to its validity.

Goals and Symptoms

To be able to use Excel as a data logger for OFS

Facts and Changes

First: You must register the attached DLL's in Microsoft Windows by using regsvr32.exe Utility.

Open a "CMD" window in your PC.
Make sure you have the DLL's in the location that the CMD widow is pointing to(C:\)
Then type in the syntax as indicated in the screen capture for the SAOFSGrpX.dll.
You need to repeat this for the second file SAOPCGrpX.dll

Launch Excel. You will need to set security in Excel to run the opcdatalog file as it has a VBA Macro associated with it.
Below is how to set security in Excel

Set it to Medium to prompt you, or Low to just run any Macro.

Once this is done open the attached file opcdatalog.xls in Excel.
You will need to change the IP address for the PLC you wish to view the data from.
To get to the VBA editor in Excel see below:

This will open the VBA editor so you can change the IP address of your PLC.

Click on the "Start Data Logging" button. This should start your OFS Server and then start logging the data for Registers
40001(HR1), 40002(HR2) and 40003(HR3).

Causes and Fixes

This should now log the data to Excel

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.