Skip to main content
InSource Solutions

TN Citect009 How to configure the Excel Add In for CitectSCADA to Develop your HMI Application

  1. Last updated
  2. Save as PDF

InSource_Logo_Transparent.png

How to configure the Excel Add In for CitectSCADA to Develop your HMI Application

 

This article from InSource shows...

  • Author: Alex Davenport
  • Published: 05/10/2017
  • Applies to: CitectSCADA 2015 upwards

 

This Tech Note will walk you through how to configure the CitectSCADA Excel Add-In to connect to your project. Once completed it will enable you to edit the application in Excel as an alternative to the native environment. 

 

1 Make sure the Project DBF Add-In for Excel has been installed. 

Excel1.PNG
 

2 Open Microsoft Excel and click on the Add-Ins Tab.

Excel2.PNG

 

3 You will see in this tab a configuration area and click on the master.dbf location.

Excel3.PNG

 

4 A browse menu appears and navigate to the Master.DBF file in C:\Program Data\Schneider Electric\CitectSCADA 7.50\User then click Open.

Excel4.PNG

 

5 You will then select your SCADA Project from the dropdown list and in this case it's called Milk Treatment.

Excel5.PNG

 

6 You have now connected to the project and we will now select the Variable Tags from the dropdown menu.

Excel6.PNG

 

7 The Variable Tags associated to the Milk Treatment project are now displayed. You may add/remove tags and once completed you click on the Save DBF button.

Excel8.png