Getting info from a web page using VBA

[greengo]

Hi all,
I’m not sure this can be done but I am want to know if it is possible to get information from a web page that is opened from a hyperlink on an excel spreadsheet. the reason for this is that I can get direct access to the database that stores the information(to much red tape) which is displyed on the page.

 

[acron]

Not sure you need VBA.

From The Data Menu select Import External Data, New Web Query, and navigate to the Web Page containing the data and take it from there.

To get a flavour of teh code involved, you could record a macro as you go. However once a query is set up all you need is a Refresh to update it.

A.C.