Hey guys, I've had some really good experiences here in the past, so I thought I'd present you with a little problem I've been having trouble solving myself.
Hardware: Allen-Bradley PLC 5/40 and Panelview 600
In concept its actually quite simple. I have a word, N42:54 that has a decimal value in it. The panelview views this word as a character array of size two and it shows up as a ASCII value. EX: N42:54 has the value "17224" which when converted to ASCII is "CH"
What I need is to somehow convert this word to ASCII and store it into a string, Call it ST15:7. I need this because I am trying to pull this value out of the datatable with OPC/DDE through MS Excel, and it pulls the value out as a decimal value instead of the ASCII. I have tried all I know, and I can't seem to get it to work.
Examples of what I have tried:
I used a TOD (to BCD) to convert N42:54 to BCD, then an AIC(Integer to ASCII string) to convert the value to a string. The BCD part worked, but the AIC just moved the result of the TOD into the string address.
I tried variations of the above, tried taking out the TOD, etc.
I am at a loss guys. Any ideas? Is it even possible?
Wes Lemstra