COM06. Connect Excel to Siemens PLC via DDE of KEPServerEX (Kepware)

แชร์
ฝัง
  • เผยแพร่เมื่อ 8 ก.ย. 2024

ความคิดเห็น • 22

  • @felipepaiva4798
    @felipepaiva4798 4 ปีที่แล้ว

    Hello! One more time, excellent video! Congratulations!!!

    • @electricalautomation
      @electricalautomation  4 ปีที่แล้ว

      Thanks! I am planning and making an entire new series of videos about engineering process modeling and PID control. Please help to forward other friends if you like them. Thanks a lot!

    • @felipepaiva4798
      @felipepaiva4798 4 ปีที่แล้ว

      Of couse yes, no doubt that would be some more good videos to this channel, i will send to my friens this kind of video, mainly cause PID is an abrangent theme at the industries, and you have a excellent didatic to give your Knowledge to us. Thanks so much! I will be waiting eagerly for your videos.

    • @electricalautomation
      @electricalautomation  4 ปีที่แล้ว

      @@felipepaiva4798 Hi my friend, please find the playlist th-cam.com/play/PL762SfoJC-e_1CtDQoRe6PYEG6Iz_zdvz.html, which is the PID and Process Object Modeling. Furthermore, the more PID videos about the PID will come soon, I am editing them these days.

  • @erdemdelibasi1315
    @erdemdelibasi1315 2 ปีที่แล้ว

    That's a great video. Regards,

  • @timkishelov9489
    @timkishelov9489 ปีที่แล้ว

    Your video helped me to use Excel with Siemens PLC simulation. Thanks! I'm using the Advanced tags to display data in Excel cells. I tried to write PLC data to Excel cells without advanced tags but couldn't make it work.

    • @electricalautomation
      @electricalautomation  ปีที่แล้ว

      I think you are having issue on the PLC Simulation. Please try to use the real hardware

    • @timkishelov9489
      @timkishelov9489 ปีที่แล้ว

      @@electricalautomation I think if I see data in the Quick Client, then I should be able to see the data in Excel. I had no problem to get data to Excel from Siemens S7-300.

    • @electricalautomation
      @electricalautomation  ปีที่แล้ว

      @@timkishelov9489 Check the CPU properties on ""permit access with put/get communication from the remote partner""

  • @ahmedabdelwahd9520
    @ahmedabdelwahd9520 2 ปีที่แล้ว

    Good video

  • @rdautomation4357
    @rdautomation4357 4 ปีที่แล้ว

    Hello,
    what kind of version of excel was used in this video? I am trying to do same, but quality is always bad, even after several minutes. All the same in KEPs, and Kep's conf. Macros conf in excel also 1:1 to this video. Excel 2019. 10 pages manual was done in Excel 2007.

    • @electricalautomation
      @electricalautomation  4 ปีที่แล้ว

      Hi My excel is Office Professional Plus 2016. You could also check two important info and setting from the video 3:12 at th-cam.com/video/pBhcizo5aYI/w-d-xo.html , and 2:35 DDE channel name at th-cam.com/video/pBhcizo5aYI/w-d-xo.html. That 10 pages include a lot important information.

  •  ปีที่แล้ว

    How i can find DDE connect document ! please

  • @andreeeeeeeee670
    @andreeeeeeeee670 2 ปีที่แล้ว

    can this be done in WPS ? thanks alot your videos are really great, any chance u have a chinese channel as well

    • @andreeeeeeeee670
      @andreeeeeeeee670 2 ปีที่แล้ว

      can the Siemen software itself do excel or to a SQL db ? why even use KepServer ?

    • @electricalautomation
      @electricalautomation  2 ปีที่แล้ว

      I don't think WPS works for this case. But you can check if KEPServerEX support WPS. Regarding directly communication to Excel and SQL. Please check the videos in my channels.

  • @miguelp7078
    @miguelp7078 3 ปีที่แล้ว

    hello, when i use the quick client it says "bad connection" and i dont know why is this. I'm working with Tia portal v16 and S7-1200 thanks! :)

    • @electricalautomation
      @electricalautomation  3 ปีที่แล้ว

      Likely it is the software problem, because the quick client is communicating with Kepware server. Please make sure the software is installed correctly, also turnoff any anti-virus software and firewall.

    • @miguelp7078
      @miguelp7078 3 ปีที่แล้ว

      @@electricalautomation now it is working correctfully thanks!! I just needed to upload the hardware and i also missing the firewall deactivation.

    • @electricalautomation
      @electricalautomation  3 ปีที่แล้ว

      @@miguelp7078 Glad to hear that! Thanks for letting me know.