Create SCADA / HMI application from Excel 2010 

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

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.

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

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

thank you Suthipong

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

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

+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

+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 .

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.

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