Excel VBA for SLC

Alan Case · Aug 4, 2005

Hi, does anyone have an excel spreadsheet with an embedded VBA function to write to an SLC using RSLinx.
The help file of RSLinx explains how to do a write to the data table but it would save me a lot of reading if someone had some sample code for me.

Thanks in advance. Alan Case

dash · Aug 4, 2005

There is acutally a tech note on the Rockwell knowledge base for using OPC within VBA in an Excel sheet & they have the spreadsheet attached to the tech note. I'll post the link if I find it.

Darren

Here is the link

http://domino.automation.rockwell.com/applications/kb/RAKB.nsf/0/B50010C75F4AE55885256AFB0059FE9F?OpenDocument

TConnolly · Aug 4, 2005

Alan you can also find some examples in RSLinx.

Start RSLinx and open Help.

Under the Index Tab type VB - then double click on VB examples. There are some Excel examples shown there.

Under the Contents tab, expand the How To chapter. Expand Using OPC. The object model is deiscribed there.

Good luck.

Alan Case · Aug 4, 2005

Thanks Alaric. I have already seen the help files.
I am pressed for time and my VB is minimal. Was hoping someone has already done this. Dash, I will check the knowledge base.
Regards Alan

tom_stalcup · Aug 4, 2005

Doesn't chakorules have something like that linked in his sig?

Excel VBA for SLC

Alan Case

Lifetime Supporting Member

dash

Lifetime Supporting Member

TConnolly

Lifetime Supporting Member

Alan Case

Lifetime Supporting Member

tom_stalcup

Lifetime Supporting Member

Similar Topics