Hello everyone, 

How can I auto update a sheet in Excel every 10 seconds after opening an Excel file? (so I can see value auto update without re-open the Excel file)

I already have a VB Script that write value to an Excel file. 

Please help me, 

Thank you.

Hi Nobita,

First to access Excel in VBS you have thousands of examples in Google. For instance :

https://www.softwaretestinghelp.com/vbscript-excel-tutorial-11/

Then you need to know how to read tags in WinCC for puting them into Excel. I don't know which version you have : Advanced or Pro ?

Then if you look in the help of WinCC you can use the objet SmartTags which works for both versions.

Best Regards,

Chulien

Hi Nobita3004

What type of WinCC you use ? WinCC Professional, WinCC Advanced?

Best regards

schufri

schufri

Hi Nobita3004

What type of WinCC you use ? WinCC Professional, WinCC Advanced?

Best regards

schufri

 Hi schufi,

I use WinCC Professional

Chulien

Hi Nobita,

First to access Excel in VBS you have thousands of examples in Google. For instance :

https://www.softwaretestinghelp.com/vbscript-excel-tutorial-11/

Then you need to know how to read tags in WinCC for puting them into Excel. I don't know which version you have : Advanced or Pro ?

Then if you look in the help of WinCC you can use the objet SmartTags which works for both versions.

Best Regards,

Chulien

 Hi Chulien,

I use WinCC Professional

I know how to use SmartTags and write value to Excel

But I don't know how can I code new value to atomatically wtitten in new cell, not overwrite the old cell

Please guide me,

Thank you

I would either save the last line used in an internal variable and increment it each time I have a new value to write or write a small functions to read excel sheet and see which line is the first empty line (maybe more robust) and then perform the write at the right line.

I don't think there's any miracle solution.

From my perspective, Nobita3004, it seems to me that you are attacking this from the wrong end. My understanding is that the shortest time interval you can schedule a task in the HMI is 1 minute. You do that under Scheduled tasks. I seem to recall seeing some threads on this subforum where people had some ingenious tricks for achieving something on a more frequent time interval, but you should understand that if you started doing too much on too regular a time basis, you might find it very resource hungry and you might start to experience some performance problems.

In any case, as I said, you going at it from the wrong end, it seems to me. Rather than having Excel sitting there passively, and having a scheduled task in the HMI writing to it, what you need to do is make the data available by OPC and have an Excel VBA macro poll the data on a regular time basis. If you don’t know Excel VBA then that is where you need to start.

But even that is not likely to be terribly robust. If the PC running Excel is busy doing other tasks, you may find it missing some records. But what you are trying to achieve is nothing new. It is generally referred to as data capture or data logging, and there are much better ways of achieving that. Both the S71200 PLC and the HMI have data logging capability. Look at ‘Historical Data’ in the HMI configuration task tree, for example.