Pulling current stock prices into Excel?

What's the best way to pull yesterday's closing prices and/or current stock prices into Excel? I want to do this for *every* traded stock in S&P500 *every* morning, rather than for just a subset.
4 answers 4