importing info from a website using a macro function

[Guest]

Is there a way to import info from a website using a macro function? and if
so, how is this process done.

 

[JulieD]

Hi

does data / get (import) external data - new web query do what you want or
what more / different do you need?

Cheers
JulieD

 

[Guest]

The problem: I have a spreadsheet that is designed to compile data and
generate charts. What they want this sheet to be able to do is go out to the
website from which the data is collected and import it into this speadsheet

 

[Guest]

The problem: there is a speadsheet that compiles data and generates charts.
What they are asking is to incorporate a macro that will enable the
speadsheet to go to a website that generates that data used in the
speadsheet, retreive this data and add it to the speadsheet each week. Can
this be done?

 

[Warzel]

Is there a way to import info from a website using a macro function? and if
so, how is this process done.

You can open a web site like a file, just type in the URL

In a module you can do it like this
Workbooks.Open Filename:="http://www.the_website_of_intrest.com/"

You can then use additional macro's to extract the data you are
intrested in.