Howto extract table from web into excel with vba-code - TechRepublic
Question
November 21, 2006 at 03:16 AM
anders_emajl

Howto extract table from web into excel with vba-code

by anders_emajl . Updated 19 years, 7 months ago

Hi guys.

I want to extract a specific table with interestrate from a website into my excel worksheet and there perform calculations based on downloaded data.

The way I remember howto do it: open the website, extract a specific table data from the tables() collection of the site, place the result into my excelsheet.

There exists a sample on the web but I can’t find it and have missplaced my copy

This discussion is locked

All Comments