scraping

  1. M

    msxmlhttp and post paramaters

    Good evening, Following a suggestion on another thread, i've been using vba with ie document to parse javascript form results Dim IE As InternetExplorer Sub Update_Price() Application.ScreenUpdating = False Set IE = New InternetExplorer Set rng = ActiveCell...
  2. D

    Best method for scraping data from Web using VB macro?

    This is something of a conceptual question rather than on the specifics of code (ie am I going about this the right way in general or is there a better technique I could use?). I think that my problem represents a broad issue affecting many of the inexperienced people who post on this forum so...
  3. D

    Curious problem copying HTML formatting from IE to Excel (but only within macro)

    Hi there, I am using MS Excel 2010 (64 bit), and IE v 9.0.8112.16421 (64-bit), Windows 7 Professional I am trying to use an Excel macro to copy data from a webpage. To do this I am automating IE in a fairly standard manner as follows: Dim IE As Object Set IE =...
  4. K

    Extract / scraping DIV data from website and copy to Excel

    Hi, Here is the challenge. In the past, elements were more or less fixed and was able to use my very well known method QueryTables under Workbooks.open This website below has a "div", called "div.sidemeta" wihick contains the information I want to grab...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top