OPC/DDE to Excel

wirelessliquid · Jan 14, 2020

HI,

I created a RSLINX OPC/DDE topic and then copied the link in to excel and I'm getting a #REF Error in the cells rather than the data, anyone have any ideas why I'm getting a #REF error?

=RSLINX|SC_SU_DL_A_FC1!'EM06_OTL_ZAxis.AccelerationFeedback,L1,C1'

Any Help would be great

cwal61 · Jan 14, 2020

=RSLINX|SC_SU_DL_A_FC1!'EM06_OTL_ZAxis.Acceleratio nFeedback,L1,C1'

Space in Acceleratio nFeedback.

I never used L1,C1 either. This should be all you need.
=RSLINX|SC_SU_DL_A_FC1!'EM06_OTL_ZAxis.AccelerationFeedback'

wirelessliquid · Jan 14, 2020

There is no space in it, for some reason the forum is formatting it with a space

wirelessliquid · Jan 14, 2020

Removing the L1,C1 seems to do the trick, I wonder why it copies this from the OPC topic link

roxusa · Jan 14, 2020

once you have copied the what you want under the edit in RSlinx DDE/OPC
and are back in excel in a box are you using paste special, and check paste link in unicode text.

OPC/DDE to Excel

wirelessliquid

Member

cwal61

Member

wirelessliquid

Member

wirelessliquid

Member

roxusa

Lifetime Supporting Member

Similar Topics