Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

DDE with Excel question

  Asked By: Patti    Date: Oct 11    Category: MS Office    Views: 897
  

I have a hardware that's reporting data over ethernet. I would like to
collect it in excel. I figure DDE would be best. Here's how it works:

1.) in order for excel to read the data, it has to perform a request
using a script written in the cell. The script is: =tnd2dde|tndwinplc!
answer1

2.) Once I press enter after entering the script, I get a number
equivalent to answer1.

I have about 6 answers I need to record (not including time/date). The
excel spreadsheet has to read the time/date and answers 1 through 6.
When done it has to advance to the next row the repeat this process.
How do I do this?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Ryder Anderson     Answered On: Oct 11

A few questions:

- How many rows of data  will be collected?
- Is this what all formulas should be?

=tnd2dde|tndwinplc!answer1
=tnd2dde|tndwinplc!answer2
=tnd2dde|tndwinplc!answer3
=tnd2dde|tndwinplc!answer4
=tnd2dde|tndwinplc!answer5
=tnd2dde|tndwinplc!answer6

- What is the formula to get the time and date(Answer 7 & 8)? Is it
stored on the device or is this going to be generated by Excel?

 
Answer #2    Answered By: Angelica Ramos     Answered On: Oct 11

There will be no limit to the number of rows of data  collected.

That is correct, the formulas will look like what you have below. One
question is if i type that in the cell, it won't accept capital
letters. In my machine, the tagnames are actually Answer1, Answer2,
etc. etc.. I guess DDE is cap sensitive cuz if I try to lowercase them
all, it doesn't work. This isn't a big problem though

Time and date will be stored in the device as strings. Probably
as "stngtime" and "strngdate".

 
Didn't find what you were looking for? Find more on DDE with Excel question Or get search suggestion and latest updates.




Tagged: