Usage of StockQuote.MSNStockQuote in excel vba code
 

Hi, any help to resolve the under mentioned issue will be greatly appreciated.

I have an excel sheet with set of stock ( company share ) symbols stored in
a column. Next column is to store the last price and column next to that
would store volume.

I use StockQuote.MSNStockQuote for finding last price ( parameters being
Symbol , "Last Price","US" ) . When I run this in a vba code loop which would
supply stock symbols , function stores #NA on excel .