Cell referencing in a DDE link formula?

**stack** · 03-03-2009, 03:16 PM

This is a continuation to my thread started in the general forum (HERE) that has transformed into a macro question.

I am using a DDE server to pull stock/option quotes into my spreadsheet. I am able to call to the server and symbols directly by using this formula:

=STIDDE|Q!'MSFT,1'

STIDDE = server
Q! = quotes
MSFT = Microsoft
1= field type (1 = Last Price, 2 = Bid, 3 = Ask, etc)

My problem comes when trying to automate the formula so that the 'field type' cells change with a change in the stock symbol.

INDIRECT/INDIRECT.EXT cell referencing doesn't work (#REF! error), so I am curious if it's possible to create a macro that will create the correct formula and update cells from the DDE links.

Any ideas?

**stack** · 03-04-2009, 10:54 AM

I recorded a simple macro that is very similar to the indirect function, where the values of the cell are pasted in another (the referenced DDE link formula). Is it possible to create an event that selects the formula bar, then presses 'Enter'?

Here is where I am so far:

C27 has the stock symbol that I want to be able to change, then referenced to in E27. F27 has the pasted value that I want to execute (press Enter). I tried to record the macro but it hardcodes the formula, instead of the events of highlighting the formula bar and pressing enter.

E27 ="=STIDDE|Q!'"&$C27&",1'"

Please Login or Register  to view this content.

Is there a workaround?

**stack** · 03-05-2009, 10:47 AM

All opinions/questions/advice accepted

**stack** · 03-11-2009, 10:27 AM

Not one suggestion? Is there something very obvious that I'm not aware of here?

**stack** · 03-16-2009, 10:03 AM

2nd to last bump!

**NBVC** · 03-16-2009, 10:50 AM

It's obviously not an easy one since you got no replies and hard to find things googling it...

Here are couple I found... don't know if you came across them or not?

http://www.mrexcel.com/archive/Links/25861.html

http://social.msdn.microsoft.com/Sea...de%20link&ac=3

Hope you get it sorted... If you do. Please post back the solution as this has been asked many times without real resolution.. as far as I can see.

**marioiturri** · 07-31-2013, 12:03 PM

Was there ever a solution to this problem?

I am trying to achieve the same..

**arlu1201** · 08-01-2013, 01:44 PM

marioiturri,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.