In Excel 2008 I get the same error unless I start CoDeSys and the application running first before I run excel. Also it seems the full path to your variable looks strange? Shouldn't it at least be .pwd_enter or PLC_PRG.pwd_enter of something like that? It is working for me on Excel 2008 using the following formula
= CoDeSys|'C:\test.pro'!PLC_PRG.sMyData
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm sorry to wake this old subject again but I have been struggeling with the same thing now for a few days.
I'm completely new to OPC handeling, so please forgive my ignorance.
I have setup the OPC-server for Codesys 2.3 and got it running with several clients (Matrikon, Softing, SST). However I would like to do a better user interface and datacollecting in Excel.
Several hours of googleing and I'm still not closer to my goal, so I humbly come to you...
I have tried Matrikons Excel Reporter, which put an add-on into Excel. This worked so far as to I was able to write to the items/variables, but not to read.
And also, this is a licensed software and for my application that's not an option.
I tried what spfeif wrote here, but the formula was not accepted by Excel. The basic formula as I enterpret it is "=(name of installed program?) | 'pathway to my program'!(item search path)
in my case when i try to access a global variable it should look like =CoDeSys|'C:\test\BL20_OPC.pro'!PLC_PRG.Test_OPC
These are the errors i get;
"Remote data not availible, another program has to start to access the data" (or something like it, translated from my native language)
"do you want to start the program CODESYS.EXE?" [Yes][NO] (yes)
"CODESYS.EXE cannot be run. The program or its components are damaged or missing"
I have tried to change the path to the Codesys.exe (c:\programs.... \codesys.exe) but to no avail.
I'm using Excel 2010 (if that matters) on a Win7 OS computer.
Please let there be someone who knows how to do this....
Thanks, br Christoffer
EDIT:
I got it working with a VB-script in Excel!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
since i will start soon with this isue and really dont want to discover the weel again in excel.
would u be so kind to shre the vb snippet it would help a lot when i start
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm running windows 7 with v2.3 and had the same problems. I still can't pull in variables from the DDE Server but I got it to work through Codesys. I took PLC_PRG off of my variable and it started working. =CoDeSys|'N:\Machine List, Standards & Controls\Paint Line\PLC\CoDeSys\Programs\Powder Line Test\Powder Line TestV2.pro'!Variable. See if this works for you guys. I would like to get this working through the DDE Server but I haven't had any luck so far. Just make sure you are logged in to your program through CoDeSys.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I need to make read /write in excel sheet from my plc which has codesys platform. I understood from posts that I need to write VB script in excel sheet for read and write ; and use formula in excel sheet .Can I anyone tell me : 1) what is use of codesys DDE SERVER here??Do we need to configure DDE server also?? If yes then how??
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I am trying to collect some data directly in Excel2003 from a Codesys based PLC always i am getting the error as "Cannot run CODESYS....."
The string (formula) i am using is the follow:
=CoDeSys|'C:\DCP.pro'!pwd_enter
I used to run similar DDE connection without any problems.
Can anybody advise if i am doing something wrong? Thank you!
In Excel 2008 I get the same error unless I start CoDeSys and the application running first before I run excel. Also it seems the full path to your variable looks strange? Shouldn't it at least be .pwd_enter or PLC_PRG.pwd_enter of something like that? It is working for me on Excel 2008 using the following formula
= CoDeSys|'C:\test.pro'!PLC_PRG.sMyData
Hello everyone,
I'm sorry to wake this old subject again but I have been struggeling with the same thing now for a few days.
I'm completely new to OPC handeling, so please forgive my ignorance.
I have setup the OPC-server for Codesys 2.3 and got it running with several clients (Matrikon, Softing, SST). However I would like to do a better user interface and datacollecting in Excel.
Several hours of googleing and I'm still not closer to my goal, so I humbly come to you...
I have tried Matrikons Excel Reporter, which put an add-on into Excel. This worked so far as to I was able to write to the items/variables, but not to read.
And also, this is a licensed software and for my application that's not an option.
I tried what spfeif wrote here, but the formula was not accepted by Excel. The basic formula as I enterpret it is "=(name of installed program?) | 'pathway to my program'!(item search path)
in my case when i try to access a global variable it should look like =CoDeSys|'C:\test\BL20_OPC.pro'!PLC_PRG.Test_OPC
These are the errors i get;
"Remote data not availible, another program has to start to access the data" (or something like it, translated from my native language)
"do you want to start the program CODESYS.EXE?"
[Yes][NO] (yes)
"CODESYS.EXE cannot be run. The program or its components are damaged or missing"
I have tried to change the path to the Codesys.exe (c:\programs.... \codesys.exe) but to no avail.
I'm using Excel 2010 (if that matters) on a Win7 OS computer.
Please let there be someone who knows how to do this....
Thanks, br Christoffer
EDIT:
I got it working with a VB-script in Excel!
since i will start soon with this isue and really dont want to discover the weel again in excel.
would u be so kind to shre the vb snippet it would help a lot when i start
I'm running windows 7 with v2.3 and had the same problems. I still can't pull in variables from the DDE Server but I got it to work through Codesys. I took PLC_PRG off of my variable and it started working. =CoDeSys|'N:\Machine List, Standards & Controls\Paint Line\PLC\CoDeSys\Programs\Powder Line Test\Powder Line TestV2.pro'!Variable. See if this works for you guys. I would like to get this working through the DDE Server but I haven't had any luck so far. Just make sure you are logged in to your program through CoDeSys.
Dear All,
I need to make read /write in excel sheet from my plc which has codesys platform. I understood from posts that I need to write VB script in excel sheet for read and write ; and use formula in excel sheet .Can I anyone tell me : 1) what is use of codesys DDE SERVER here??Do we need to configure DDE server also?? If yes then how??
Hi,
wich CODESYS Version and which plc are you using?
There is an OPCUA posibility if this is supported by your plc.
BR
Edwin