Create SCADA / HMI application from Excel 2010

[@SinETiquetaPuntoCom]

Hi @ Sutthipong Senatee. do you know how read a Modbus RTU from a Serial Port and show the data in a Excel File? Thanks for your videos!

[@DQ_CONTROL]

Ya no funciona. año 2020. por favor hacer una versión para Windows 10 de 64 bits. Gracias :)

[@scadaiot]

Please note that you need Excel 32bit, not Excel 64 bit.

[@mertkellecioglu2928]

Hi. I installed the COPC32 but I cant see svrname box is coming empty in OPC_Server tab @ COPC32 properties page. Why can it be ?

[@scadaiot]

Which opc server you have? If possible, please install kepware kepserverEx to have opc component. This will make sure you have opc component installed.

[@Scout0013]

สุดยอดเลยครับจ๋าน แต่พื้นฐานผมน้อยมากครับ

[@Zurenio]

Very good.... fantastic....!

[@fanystason]

Can you get it on modbus tcp ?

[@mshari99]

i have one PC running on (SCADA)gateway protocol 101 to send data to remote location .... can i use this method on this PC to log data on excel sheet .

[@scadaiot]

Yes you can do if it is OPC Server on that PC. You can use COPC32 on Excel or on Visual Studio to getting data from OPC Server and logging to excel sheet.

[@mshari99]

how can i know that it is a OPC server( don,t know about OPC server). My PC running on Windows xp and PACIS gateway (schneider) software to fetch data from field PCs for sending data on 101 protocol on RS232 port..... how can i know that there is OPC server runnig.?/ thanks

[@scadaiot]

Srihari Munagala You can use OPC Explorer application to find out are there any OPC Server on your PC. www.opcconnect.com/freecli.php#testcli

[@mshari99]

thank you Suthipong

[@olufemitosin3526]

Hello, how can I get a sample of your workbook?

[@icanfashionchannel3156]

Translate Thai is ok. Very good

[@1990acustico]

how is serialcom?

[@hisyst]

Very good interesting

[@RS-kx9rp]

good works

[@hamzarguig6659]

i can find servers to chose one of them ! what's wrong ? Help!!!

[@scadaiot]

+Hamza Rguig Do you mean only one OPC server available? If yes and you have many OPC Server, please checking is it any DCOM config needed for that OPC Server. If you connect to local OPC Server, it could be available on OPC browser as default. Please use OPC Quick client to check. Download OPC Quick client from kepware.com

[@hamzarguig6659]

+Sutthipong Senatee i can find only one server and when i chose it i don't find any tags inside ? Im working on vijeo citect scada and want to make my trend on excel tab .

[@scadaiot]

I think it is about DCOM security. You may want to use COPC DLL instead of COPC32. Then you can specify the name and amount of OPC tags.

[@hamzarguig6659]

okey i will try this . thank you waiting your new videos ;)

[@naderchinichian]

where can I download cpoc32?

[@scadaiot]

Download COPC32 at www.eda.co.th/COPC.htm

[@alexeyk.9226]

super

[@adilelhoukssous9199]

thank u