Help with DDE - stock feed

[rotem]

Hey All,

i am using excel 2007, i am not an expert at all with coding.

i am trying to capture DDE stock feed and record every change in the
price cell into a growing column.

so assume the DDE link will be placed at cell A1 and i am trying to
get the Excel recording every change into say Colume C which will
grow.

i have already tried several other codes - but with all of them the
problem was that when i plugged the DDE-- the code did not work from
some reason.


hope you can help me with that

thank you,

ron

 

[joel]

I think the best solution is to find out why the other Macros didn't
work. I suspect that the answer if simple why the other methods didn't
work. I thinnk ther is a reference to a library that you need to add
into your VBA. VBA has a menu Tools - Reference and when you use some
application software you need to select some of the references in the
list. Without seeing the macro You are using I can't tell which library
you need to add. Yo need to either go back to the website you got the
code from and read the webpage carefully and look for "REFERENCE". if a
reference is missing, VBA will indicate this with an error message and
highlight the line of code in yellow. If yo post the highlighted line
and the exact error message we can help.