Excel Macro to fetch results from web based on the input stored in Cell1 of Column A, Cell2 of ColumnA until  next 10 cells

I got a CSV file which looks like this when i open up in excel

COLUMN A

M

MSFT

KSS

AMZN

For each of the cell in column I would like to Macro to get the data from the web using the query xyz://finance.yahoo.com/q/ks?s="&$A$1&"+Key+Statistics","table", 11

when I execute the Macro, it should go to first M and execute the query (xyz://finance.yahoo.com/q/ks?s="&$A$1&"+Key+Statistics","table", 11) and fetch results into Column B 1

when I execute the Macro, it should go to first MSFT and execute the query (xyz://finance.yahoo.com/q/ks?s="&$A$1&"+Key+Statistics","table", 11) and fetch results into Column B 2

Any help in this matter is greatly appreciated. I am challenged with Macro code.

June 12th, 2015 3:59pm

Hi,

Your question is not very clear.  are you trying to write a macro in loop which takes M, MSFT etc as Key to execute the query and fetch the data?

Please specify it clearly.

Free Windows Admin Tool Kit Click here and download it now
June 13th, 2015 4:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics