azecraze

You need RSLinx on your computer, and the correct cables and other hardware depending on the protocol you are using to communicate between PLC and PC. Set up correct drivers in RSLinx to talk to your PLC, then when you are online to your PLC and it is visible in the RSWho window, select the data word or bit you want then copy and paste a link to this into your excel spreadsheet. You can also 'tweak' the formula in excel to select the whole word, or only a bit in the word.

I just put a new DDE logging file in the downloads section. Chakorules, I will still be using the data logging file you created, as it has good daily saves. I have had your one running permanently since I set it up, and it works ultra well. I also needed one to do quick one off logging - namely to monitor a PID. So here it is.

File Name: Simple Excel PLC Data Logger File Submitter: azecraze File Submitted: 16 Sep 2004 File Category: HMI Sample Code Have you ever wanted a straight forward data logger? Have you ever wanted to log at speeds greater than 1 sample per second? This is a simple one off file with up to 10 streams logged but no time stamp. The purpose of this file is to provide a Click here to download this file

Ok Chakorules, I have finally got it running - with your help. The problem was the references to the incorrect topic name in the macro. Now that it is going I will be changing around some of the less important stuff, like column names and the pass/fail section. Thankyou for going to all the trouble and effort of coding all this and then just making it available to people like me. I do very much appreciate it. regds AzeCraze.

Chakorules, Everything seems to be running, except for the fact that I am not getting any data on the sheet. 1/ Do I need to change any Topic references in the macro from M1138 to my topic? 2/ I have changed B/161 & B/163 to this in the macro: CODE 'assign PLC bit values to VB variant varibles varLogging = DDERequest(RSIchan, "B3:0/1") varCycle = DDERequest(RSIchan, "B3:0/0") What is the purpose of: varLogging = DDERequest(RSIchan, "B3:0/1") Nothing will happen without this toggled on, but I still get no data onto even when it is toggled on. I have tried changing these: f810data = DDERequest(RSIchan, "F8:10") to bit and word addresses like this: f810data = DDERequest(RSIchan, "B3:0/0") f810data = DDERequest(RSIchan, "B3:0") All the green lights are on, and the DDE link says active. How long does the GET DATA bit need to stay on for it to work? Maybe I need an OSR on the rung?

Thanks Chakorules, I will have a go at all that and see what I come up with.

I have already PM to Chakorules on this topic but anyone who can help.......: In the downloads section of this site there is a file called "Allen Bradley SLC500 DDE Link to Excel Logger 1.4" Can someone - preferably the author (chakorules) please advise me as to whether they have had this working. I am using an Allen Bradley ML1200 and I was wondering if you could point me in the right direction as to what is the correct changes I need to make in the macro for it to run correctly using this PLC, as I have only limited skills in VBA. I will also be wanting to change the data input from reading Forces, to reading in Binary and Integer values. I have the following installed, and can do a simple DDE: Allen Bradley ML1200 RSLinx Single Node MSExcel