Forums.MrPLC.com: excel, dde, and supervisor 1 to 3 - Forums.MrPLC.com

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

excel, dde, and supervisor 1 to 3 Rate Topic: -----

#1
User is offline   omronbleah 

  • Newbie
  • PipPip
  • Group: MrPLC Member
  • Posts: 5
  • Joined: 14-June 11
  • Country:Italy
    Italy
hello, sorry for bad english

we upgraded supervisor from 1.2 to 3

and now the dde command DDEEXECUTE doesn't not work

(other function are ok, ddepoke, etc...)

any suggestion ?
sorry for bad english !!
0

#2
User is offline   Berti Baker 

  • Sparky
  • PipPipPip
  • Group: MrPLC Member
  • Posts: 220
  • Joined: 26-July 06
  • Country:United Kingdom
    United Kingdom
Hi,

I seem to remember this got broke in the Unicode version (V1.3) and never got fixed afterwards. DDE was to unstable and there were better ways.

Tell us what you're using DDE for and we'll give you a better way, for example How To Read And Write To Excel Cells From CX-Supervisor

Regards,
BB
0

#3
User is offline   omronbleah 

  • Newbie
  • PipPip
  • Group: MrPLC Member
  • Posts: 5
  • Joined: 14-June 11
  • Country:Italy
    Italy
1.3, true !!! i remember
see it at step from 1 to 1.3
and fixed installing 1.3 and then replacing with 1.2
now with v3 i dont want to do this again

i use it to write a lot of data in a excel file...
a quick solution is welcome (example, change the syntax to the non working instruction "ddeexecute")

in a pc i've already made a new way, write all data in a csv file, and then import this file with excel

i've other pc, now they are working with 1.3 + 1.2, i'm waiting another solution before install v3 on them



EDIT

in every application there is an automatic script, wich at midnight stores data of the day in the excel file

This post has been edited by omronbleah: 17 June 2011 - 06:38 AM

sorry for bad english !!
0

#4
User is offline   Berti Baker 

  • Sparky
  • PipPipPip
  • Group: MrPLC Member
  • Posts: 220
  • Joined: 26-July 06
  • Country:United Kingdom
    United Kingdom
Hi,

Yes the example How To Read And Write To Excel Cells From CX-Supervisor might be useful to you then, or for more organised data logging it is worth looking at Setting Up Data Logging On CX-Supervisor

Regards
BB
0

#5
User is offline   Jay Anthony 

  • Omron Expert
  • Group: MrPLC Admin
  • Posts: 2,853
  • Joined: 12-January 02
  • Gender:Male
  • Location:Dallas, TX
  • Interests:Omron Tech guy
    Sound and Stage Lighting,
    Computers Rock!
  • Country:United States
    United States

View PostBerti Baker, on 02 July 2011 - 10:38 AM, said:

Hi,

Yes the example How To Read And Write To Excel Cells From CX-Supervisor might be useful to you then, or for more organised data logging it is worth looking at Setting Up Data Logging On CX-Supervisor

Regards
BB

Awesome Berti! :notworthy:
Posted Image
Jay in Dallas
0

#6
User is offline   omronbleah 

  • Newbie
  • PipPip
  • Group: MrPLC Member
  • Posts: 5
  • Joined: 14-June 11
  • Country:Italy
    Italy
ok, downloaded example
i'll try.. after holidays

thx :-)
sorry for bad english !!
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users