Using Multiple Web Queries for hyperlinks in cells

  • I am wanting to do web queries for a lot of different stock tickers (maybe around 1000). All my links are in the excel worksheet, so I am wanting to have it automatically go through, copy the link from the cell, paste it into the get external data from website feature, and return the results on a new worksheet for each query. I have little experience with VBE, but can kind of understand it. If there is any way to do this easily please let me know.

  • Re: Using Multiple Web Queries for hyperlinks in cells


    Hi sd11089,
    Nice to meet you.
    Before run macro, add sheet named 'Query'.


    Have a look at this page too.
    http://finance.groups.yahoo.com/group/smf_addin/
    Regards, junho

  • Re: Using Multiple Web Queries for hyperlinks in cells


    I really appreciate the help, but Im still stuck. I added worksheet 'Query' and ran this macro, but Excel says not responding every time. Im looking through this code, and am wondering if this is based off the excel sheet I posted earlier, because there is a reference to 'Sheet1' which I don't have. Also, am I supposed to move the ticker symbols I want to be processed onto the new Query page?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!