I'm thinking this is a very simple thing to do but I have not been able to figure it out yet. I'd like to download closing prices through the DDE link. A few hundred tickers. I dont have a problem with the VBA code. Its just the DDE formula that I cant get to work. Any help would be greatly appreciated...thanks.