Automatically retrieve Mutual Fund Data

Hello!

The goal here is to create a macro that will retrieve mutual fund info. Not the real-time quote but data about the mutual fund. Here is the macro that I recorded. The challenge is in being able to set things up such that the user can input up to 10 ticker symbols and grab, specifically, the Max Front End Sales Fee.

My macro hardcoded the ticker GEGAX.
How can this be set up such that user can load tickers into range A5:A14?

Please Login or Register  to view this content.

The code below wonderfully extract live quotes. And if the ticker symbol is bogus, this returns "???'" All good.
I've been trying to modify this code to retrieve the Max Fee but it's not going so well.

Please Login or Register  to view this content.

Still in need of help.

In Steps 3 and 4

The data on Web Query Page in range D5:I5 needs to go Stock Symbols in cells F:K on each row. Instead, it's bringing blank cells. I know this because I've had content in those cells and the code wiped out the content.

The code is doing fine picking A5 on WQP and putting it in Column B on the Stock Symbols page.

What's missing?

Please Login or Register  to view this content.