Help with DDE - stock feed
in [Programming]
|
Prev: Excel VBA Populatig UserFrom Contols as Design Time.
Next: Replace manual line breaks (Alt+Enter) with two spaces for selected cells
From: rotem on 21 Mar 2010 02:01 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
From: joel on 21 Mar 2010 07:11
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. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=189275 http://www.thecodecage.com/forumz/chat.php |