You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

---------->>>>>Get FREE PLC Programming Tips

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

PLC training tools sale

Reply
 
Thread Tools Display Modes
Old December 6th, 2005, 07:52 PM   #1
mrdmrd
Member
United States

mrdmrd is offline
 
Join Date: Dec 2002
Location: Nebraska
Posts: 77
DDE Excel question

Hello everyone

I have a quick question.

Excuse the Noob question.

I am trying to learn DDE stuff. My question is that assuming that I am using an AB PLC, If I use the DDE to copy the value of N7:0 to Excel and place it in cell A1, and the value of N7:0 changes will Excel automaticly update or how do I go about updating the information.

Thanks
  Reply With Quote
Old December 7th, 2005, 04:49 AM   #2
Bob O
Member
United States

Bob O is offline
 
Join Date: May 2003
Location:
Posts: 1,527
mrdmrd,
I just tested a DDE link into excel and it did update on change.
Hope that helped.
Bob O.
  Reply With Quote
Old December 7th, 2005, 06:18 AM   #3
Ken Moore
Member
United States

Ken Moore is offline
 
Ken Moore's Avatar
 
Join Date: May 2004
Location: Upstate South Carolina
Posts: 2,325
When you configure your DDE topic in Rslinx, under the Data Collection Tab, there is a setting for polled messages, if you choose this, and then set a time in msecs, such as 1000, then the data will be updated every 1000msecs.

Hope that helps,

Ken
__________________
"To give real service you must add something that cannot be bought or measured with money; and that is sincerity and integrity."
- Donald A. Adams

  Reply With Quote
Old December 7th, 2005, 06:56 AM   #4
mrdmrd
Member
United States

mrdmrd is offline
 
Join Date: Dec 2002
Location: Nebraska
Posts: 77
Thanks guys this is what I needed to know

Thanks again
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
Using Excel and DDE to collect data SilverLoop LIVE PLC Questions And Answers 14 April 13th, 2005 09:52 AM
OMRON DDE to EXCEL guest LIVE PLC Questions And Answers 1 November 10th, 2004 07:22 AM
DDE to Excel guest LIVE PLC Questions And Answers 0 November 5th, 2004 06:59 AM
Using DDE with Excel installed on other pc mulderm LIVE PLC Questions And Answers 3 July 22nd, 2004 04:23 AM
EXCEL Recording From DDE Kabir LIVE PLC Questions And Answers 10 March 26th, 2004 03:06 AM


All times are GMT -5. The time now is 08:59 PM.


.