Downloading data from a web page

  • Thread starter Thread starter Don Guillett
  • Start date Start date
D

Don Guillett

It might help if you posted the url, the method of query, and the data that
you want to get out of it. One way is to load to a dummy page and then have
a macro to collect what you want to the final page.
 
Hi

I want to extract a small bit of data from a web page a place it in a
range.

At the moment I'm doing it using web query, which unfortunately, as far as I
know, needs to display all the data in a worksheet before I'm able to take
the bit I require.
I would like to avoid this, if possible.

Do you know if ADO would be a solution?

Would the format of the web page make a difference?
I think it's XML, but to be honest, I'm not to sure what that is.

TIA
Dave F..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Download Web Pages/Files -- Need Delay 1
How to get a file from a web page 1
Importing data from the web (script page) 5
Importing data from Web using Excel 3
Capture Web Page Source Code 5
Macro to execute at a set time, pull data off of a web page, and e 1
Capturing web page load times from VBA 3
Importing several web pages with macro/VBA? 9

Back
Top