tds

  1. Nelson78

    VBA and Excel: sporadic error 91 in grasping huge quantity of datas from the web

    Hello everybody. I've been grasping a lot of data from a website via Excel using the following code. Dim tbls, tbl, trs, tr, tds, td, R, c Set tbls = IE.document.getElementsByTagName("table") For R = 0 To tbls.Length - 1...
  2. Nelson78

    Vba: extract a single data from a table

    Hello everybody. I succeeded to import an entire table from a web page. But my need is importing just a single data and writing it in Worksheets("General").Range("A1") The table has 27 columns and 21 rows: how can I import the value with the following coordinates: column 11 row 4 Dim...
  3. J

    Trying to get tables from a piece of code

    Hi everyone, I need your help to figure how can I take from a piece of code an table to excel. I find where table is and I create a variable to put the table in, but when I try to use that piece of code like html document, vba shows me this message: "Run-time error '424': Object required"...

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
Back
Top