For statement help
I have made a program which using DDE communications imports and export data from a PLC. In order to save myself some time (since I have many values to impor and export) I am trying to use a for statement with an embedde variable so to speak. My values are set up as AnalogInputs[0].Value AnalogInputs[0].Fault AnalogInputs[0].Alarm etc etc with about 10 elements in eac AnalogInputs[x]. I need to read these values for the first 26 analo inputs and read them into excel starting at F75. Read all values i down to F85, then skip a line and continue with AnalogInput[1]. This is quite easy to do in the PLC programming code. It would b something like: y=75 FOR x = 0 to 26 AnalogInputs[x].Value = Fy AnalogInputs[x].Fault =Fy +1 etc etc y=y+1 (for the space which im not sure how to add in excel) end for The main problem is that I dont know how to use the x value so that i is embedded in the analog input. I also dont know how to add the spac (though I am sure it is a relatively simple function) Any help would be appreciated -- pete358 ----------------------------------------------------------------------- pete3589's Profile: http://www.excelforum.com/member.php...fo&userid=2840 View this thread: http://www.excelforum.com/showthread.php?threadid=47992 |
All times are GMT +1. The time now is 12:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com