I've been using this stock query for several years with no problems. However, within the past year, this query fails to bring in

all of my 12 stock tickers - sometimes it works, sometimes it doesn't. I only run the query when the market is closed.

Selection.QueryTable.Refresh BackgroundQuery:=False

Can someone post a relativity simple stock query that will work in both Excel 2003 & Excel 2011 (Mac)?

Suggestions greatly appreciated - I'm definitely not an expert in macros but I can write simple ones.

Jim