RSLinx DDE and Excel

Marie1982 · Feb 7, 2007

Hello guys,

I'm trying to read a block of words from a ControlLogix into Excel using a DDE channel. In Excel, i'm using a macro activated by a button to do the reading. The code is in VBA. I found the code in RSLinx help, here it is:

"Excel DDE macro: read a block of words

Reading data from a PLC via DDE requires a macro like the following. This macro assumes that there is a worksheet created and saved as RSLINXXL.XLS. This is the destination of the data that will be read by the macro. This routine reads a block of five words:

Sub Block_Read()

'open dde link: testsol=DDE Topic

RSIchan = DDEInitiate("RSLinx", "testsol")

'get data and store in data variable

data = DDERequest(RSIchan, "N7:30,L5,C1")

'Paste data into selected range

Range("[RSLINXXL.XLS]DDE_Sheet!A7:A11").Value = data

'close dde link

DDETerminate (RSIchan)

End Sub "

I wrote exactly that code and when I activate the macro, I get the "error 438: Property or method not supported/managed by the object." If I click on debug, it higlights the line with the DDERequest command.

Do you know how to get rid of that error?????

Thank you very much

Marie

rdrast · Feb 7, 2007

Step through it. What line exactly is this failing at?

And, what version of Linx are you using?

Marie1982 · Feb 7, 2007

As I said, the error is at the line with the DDERequest command.

The version of RSLinx is RSLinx Classic V. 2.50.00.20 (CPR 7)

Marie

TimWilborne · Feb 7, 2007

Which flavor or RsLinx do you have? Lite, Single Node, OEM, Gateway, or Professional?

Mickey · Feb 7, 2007

The OP is using a contrologix, I don't believe it supports a data type of N7:30. Maybe a tag name. ( note: I have never done this)

cbeck77 · Feb 7, 2007

Probably an easy way of getting the correct syntax for the controllogix is to go into RSLinx, Edit, Copy DDE/OPC Link. This way at least you know the syntax is correct when you past it in the cell.
Also check you version of Linx like the others have said...I've never really used DDE in Excel but I assume you need higher than Lite.

TimWilborne · Feb 7, 2007

Mickey's right. It should be a tag like MyInteger or something. What tag are you trying to read in the Controllogix?

TimWilborne · Feb 7, 2007

Actually you are specifying a length of 5 so it would have to be an array like MyInteger[0].

Give us the tag and the number of elements you want to read

Marie1982 · Feb 8, 2007

I got it working today!

Thanks for your help!

Marie

CeCo3 · Feb 8, 2007

Marie,

I am curious what you did to make it work. Did the Excel VBA macro work after making the changes for ControlLogix?

Regards,

CeCo3

daba · Feb 9, 2007

No need to use a macro, simply type the request for data into a cell - example to read PV of a PID tag called "MyPID" :-

=RSLINX|MyTopic!MyPID.PV

MyTopic is the RSLINX topic name, pointing at the contoller.

If you try to address an array tag - such as MyArray[13], the square brackets cause errors, so you need single quotes around the tagname :-

=RSLINX|MyTopic!'MyArray[13]'

Marie1982 · Feb 9, 2007

That's exactly what I did...

Someone told me about the request that can be used in Excel.

Marie

neo1125 · Nov 12, 2007

ok thats what i have also done so far, now i have real time data in a excel cell. Now what if i want to log it, lets say, twice a day?

rta53 · Nov 12, 2007

neo1125 said:
ok thats what i have also done so far, now i have real time data in a excel cell. Now what if i want to log it, lets say, twice a day?

We do this all the time. We just move the data into temporary memory locations which are referenced in excel and then save a copy of the excel file. You can automate the entire process using vba.

neo1125 · Nov 12, 2007

can you please specify via an example... i m a novice in vba

RSLinx DDE and Excel

Marie1982

Member

rdrast

Lifetime Supporting Member

Marie1982

Member

TimWilborne

Lifetime Supporting Member

Mickey

Lifetime Supporting Member

cbeck77

Member

TimWilborne

Lifetime Supporting Member

TimWilborne

Lifetime Supporting Member

Marie1982

Member

CeCo3

Member

daba

Lifetime Supporting Member

Marie1982

Member

neo1125

Member

rta53

Lifetime Supporting Member

neo1125

Member

Similar Topics