Data from Excel to an AB PLC - PLCS.net

edwardt · October 26th, 2007, 02:44 PM

I know how to view data in excel pulled from a plc, but how do i go the other way? I would like to be able to, for instance, write a 1 to a certain bit in the processor.
Thanks

curlyandshemp · October 26th, 2007, 02:52 PM

Quote:

Originally Posted by edwardt

I know how to view data in excel pulled from a plc, but how do i go the other way? I would like to be able to, for instance, write a 1 to a certain bit in the processor.
Thanks

From Knowledge database

Oakley · October 27th, 2007, 08:19 AM

Not too long ago, was was investigating VBA scripting to write an application in Excel to read/write data to a controller. RA has a example that does exactly what you want. It is on their website somewhere. Just do a search. If you can't find it, let me know and I will try to find it again.

OkiePC · October 27th, 2007, 05:09 PM

Using a purchased version of RLinx, you can use DDE to do this from an event in excel.

If you are already reding values using the Copy and Paste DDE Link feature, then your are 90% done.

You will have to detemine the event(s) in terms of Excel, in which you want to send a DDE update to the PLC.

You will have to edit a VBA routine for the event you choose.

In the code you will open a DDE channel, write the value, and, at some point in the excel application, you will close the channel.

There is an oversimplified example in RSLinx Help, search for topic "Excel".

There is a fantastic example at MrPLC.com

Paul

October 26th, 2007, 02:44 PM	#1
edwardt Member Join Date: Oct 2007 Location: Milwaukee Posts: 9	Data from Excel to an AB PLC I know how to view data in excel pulled from a plc, but how do i go the other way? I would like to be able to, for instance, write a 1 to a certain bit in the processor. Thanks

October 27th, 2007, 08:19 AM	#3
Oakley Member Join Date: Oct 2004 Posts: 1,047	Not too long ago, was was investigating VBA scripting to write an application in Excel to read/write data to a controller. RA has a example that does exactly what you want. It is on their website somewhere. Just do a search. If you can't find it, let me know and I will try to find it again. __________________ Artificial intelligence never overcomes natural stupidity.

October 27th, 2007, 05:09 PM	#4
OkiePC Lifetime Supporting Member Join Date: Mar 2005 Location: ENE of Nowhere Oklahoma Posts: 7,494	Using a purchased version of RLinx, you can use DDE to do this from an event in excel. If you are already reding values using the Copy and Paste DDE Link feature, then your are 90% done. You will have to detemine the event(s) in terms of Excel, in which you want to send a DDE update to the PLC. You will have to edit a VBA routine for the event you choose. In the code you will open a DDE channel, write the value, and, at some point in the excel application, you will close the channel. There is an oversimplified example in RSLinx Help, search for topic "Excel". There is a fantastic example at MrPLC.com Paul __________________ It's not all the variables I am most concerned with, it's the undiscovered constants. "You can lead a horse to water but if he's got his head up his as$ he may die of thirst anyway."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Topics
Thread	Thread Starter	Forum	Replies	Last Post
PLC AB SLC 503 error fatal, acces data files	freepat	LIVE PLC Questions And Answers	2	September 29th, 2007 04:32 PM
Downloading Allen Bradley PLC Data to a Access Database	bigvicfella	LIVE PLC Questions And Answers	5	January 25th, 2007 12:31 PM
EXCEL Data to AB PLC5	vb12345	LIVE PLC Questions And Answers	9	September 19th, 2005 01:53 PM
Simulator, Simulation, Shadow Code	Terry Woods	LIVE PLC Questions And Answers	1	January 2nd, 2005 01:40 PM
AB RSlogix Plc data to Excel	SAMTORRES66	LIVE PLC Questions And Answers	3	March 5th, 2004 12:09 PM



This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
*Try our online PLC Simulator- FREE. Click here now to try it.* ---------->>>>>Get FREE PLC Programming Tips

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)