RS 500 Data Collection-imported to excel

[dpinegar 0]

Hi, I'm new here and was wondering if anyone has imported data to an excel spreadsheet before? I have multiple processors on a DH+ network and can see all of them on my office computer via rslinx(gatway). What I would like to do is have an excel spread sheet that I can see when a processor has alarm conditions. I already have alarms setup in each processor for VFD fault, Proximity switch fault, ect. but I have no formal way to view the status of the bits globaly. Instead of looking at each processor individually. I would also like to do some trending of the data for records but I think I would have to bring all of that data into a seperate processor first, then do some logic to count the frequency of the alarms and how long they happen, then import the values to a spreadsheet. But then I'm back to not knowing how to import the data... Thanks for any ideas or tips.

[TimWilborne 108]

You can use DDE to read and write values to excel through RSLinx. Go to RSLinx and do a search on DDE. There are some program examples there Edited 12 Oct 2005 by TWControls

[Chris Elston 79]

Always check the downloads sections. Chances are good there is an example. Here is an application I did. http://forums.mrplc.com/index.php?act=Downl...&CODE=02&id=134

[OkiePC 14]

You need RSLinx pro, gateway, OEM..etc. NOT RSLinx Lite. Then it's a piece of cake using the instructions in RSLinx help. Go to RSLinx help and search for "excel".