Following links in VBA

[JavaJesus05]

Ok, I've got these reports that are going to be dealt with every month or so, and I've been asked to make them as simple as possible so that they can be done quickly. Currently, whenever there's something in the report that needs to be looked at, whoever is working the report needs to follow a link associated with that bit of data and figure out what's going on. So I was wondering if it would be possible to have a macro follow some link and copy the data into a new worksheet or something.

[RobDog888]

What app are you using? What type of links are these? (targeted to a workbook, document, or web page?).

[JavaJesus05]

.....I knew my post seemed kind of bare...

Anyway, this is in Excel with links targeting a webpage.

[RobDog888]

You can use the .FollowHyperlink method but depending on the webpage you might be better using a webquery to load the pages' contents into a specific sheet/cell.

[JavaJesus05]

Would you mind providing a link to an explanation of the webquery? Or if you feel like explaining it here, that would work as well.

[RobDog888]

Data > Import External Data > New Web Query...

And follow the steps/enter in your webpage address.

[JavaJesus05]

Thanks for the help, but unfortunately I can't record the data import and so I can't add it in to a macro that the technology-challenged would be able to use. *sigh* oh, well.