Announcement

**ACM** · 04-28-2008, 10:54 AM

Re: DDE Output Of FirstXminsHL.efs

merchant
Post the code as you have modified it so that someone can assist you in fixing it.
You may also want to review this thread on the subject of the DDE Object in which you can find detailed examples on how to use it
Alex

PS. For your information your other post on the same subject has been removed as it was a duplicate of this one.

Originally posted by merchant
Hi,

I have been trying to output the High and Low of the FirstXminsHL.efs without any success, please can you help.

Thankyou

**merchant** · 04-28-2008, 02:25 PM

Hi Alexis,

I have attached code for FirstXminsHL.efs, I have made additions to the code in lines 1,8,96,97,98,101,102.

In excel I use the follwing to try and retrieve the value from the EFS =Esignal¦EFS!vHighES M8_1

Would appreciate your help

thanks

Attached Files

ddehl.efs (3.0 KB, 200 views)

**ACM** · 05-01-2008, 11:34 AM

merchant
There are several errors in the script.
- In a function within an efs any code that follows the return statement will not be executed. This means that the whole section of code in lines 93-104 of your script is not going to be executed.
- In that section you also added lines of code (specifically lines 93, 101 and 104) that are not required by the script. Comment them out for now (so as not to displace line references) and delete them once you have the script working.
- This leaves lines 96-99 and 102 which need to moved and inserted in line 89 ie prior to the return statement.
Once you make these changes the script should output the value to Excel
Also keep in mind that in Excel you will not be able to use spaces and/or special characters (such as for example $) in the symbol so in the efs you will need to replace the spaces and the characters with (for example) an underscore. For a complete sample code on how to do this you may want to refer to the thread I indicated in my previous reply
Alex

Originally posted by merchant
Hi Alexis,

I have attached code for FirstXminsHL.efs, I have made additions to the code in lines 1,8,96,97,98,101,102.

In excel I use the follwing to try and retrieve the value from the EFS =Esignal¦EFS!vHighES M8_1

Would appreciate your help

thanks

**merchant** · 05-05-2008, 12:47 PM

Alexis,

Thanks alot works great !!!!

**ACM** · 05-05-2008, 02:11 PM

merchant
You are most welcome
Alex

Originally posted by merchant
Alexis,

Thanks alot works great !!!!