OPC Server and Excel

M

Thread Starter

Michel

Hi friends;

I hope any one use the peakHMI server and client.
I install the server. Then go to communication OPC CLIENT configure it. In configuration Points are generated with OPC and check the box OPC PUBLISHED.

Now i open the excel 2000 what is the steps to take data into excel?
Is there any code need to write in VBA or what steps take to configure excel to read the real time data into excel?
Regards
 
Hello,

>> I hope any one use the peakHMI server and client.

I do. ;)

I have never used Excel to access the data via OPC. With PeakHMI not running, make sure you run the execute the 'RegisterOPCServer' batch file in the 'Tools' directory.

This web-site had some information: http://www.faweb.net/us/opc/sample_excel.html

By the way, PeakHMI can automatically output tag data to an Excel spreadsheet. It is very easy to setup.

If you need some help contact support. The address is in the about box.

Good luck,

Mark
http://www.peakhmi.com/
 
Hello wasim

I install the matrikon server for GE and excel reporter. I configure the server and excel reporter but not successful to read and write data.

If u have any example in which step by step configuration of server particularly for GE plc server along with Alias configuration and excel reporter configuration plz send me.

Secondly can i use VB2008 with the server i need code how to connect with the server and read/write data from form which i make. I have all images step by step i did configure but here no option to upload in control.com.

U can visit to see images which i post at



IMG]http://i53.tinypic.com/2u8dpa0.jpg[/IMG]





Please see the images and guide me.
Thanking you i will remain
 
Dear friends;

Any one aware how to use Martikon OPC server and excel reporter. i use and attached image but i am not successful.

Regards

<b>[Moderators note: links to images are listed in previous message]</b>
 
> Any one aware how to use Martikon OPC server and excel reporter. i use and
> attached image but i am not successful.

Dear friends;
Please help in this issue?
Thanks
 
W

Wassim Daoud

Hi Michel,

Sorry that you are having some difficulties with this. I just spoke with the Global Support Manager about this and he recommend calling him at his personal cellphone to address your problem: 780-233-0196

Cheers,
Wassim
 
You can use www.rbsreport.com

> I hope any one use the peakHMI server and client.
> I install the server. Then go to communication OPC CLIENT configure it.
> In configuration Points are generated with OPC and check the box OPC PUBLISHED.

> Now i open the excel 2000 what is the steps to take data into excel?
> Is there any code need to write in VBA or what steps take to configure excel to
> read the real time data into excel?
 
Hi,

Since you bring up a post that is three years old I will add more.

Since my original response, I created several projects using Excel as an OPC client to connect to our OPC data access server.

Contact support if you need any help.

Regards,

Mark
http://www.peakhmi.com/
 
Top