How to use VBA and web browser to load web pages from a list

[Guest]

Using access 2000 or 2002 or excel 2002, I want to be able to supply a list
of documents on the web, including the full path, and navigate to each in
turn.

 

[Dirk Goldgar]

Using access 2000 or 2002 or excel 2002, I want to be able to supply
a list of documents on the web, including the full path, and navigate
to each in turn.

Given a string containing the URL of a web page, you can use
Application.FollowHyperlink to open that URL in the default web browser.
In Access, you'd open a recordset on a table containing the list of
URLs, then loop through the recordset to visit each URL in turn.
However, I think this is going to open a separate browser window for
each URL, with no way to wait until the previous one is closed. If you
want to do that, you probably need to use a form with a "Next" button to
control the looping.

It's also possible to put the Microsoft Web Browser control on a form,
and manipulate the properties and methods of that control to navigate to
the URLs.