How to download a HTML table from a Web site into Excel

  • Thread starter Thread starter Belinda
  • Start date Start date
B

Belinda

Hello All

I am trying to download a HTML table into a Excel spreadsheet can you
please let me know the best way to program the download of this into
Excel.

Thanks
Belinda
 
Tom

Is there something similar to bring a html table into the existing workbook and to a specified sheet?
 
Data => Get External Data => new web query.

--
Regards,
Tom Ogilvy

Joe said:
Tom,

Is there something similar to bring a html table into the existing
Click to expand...
workbook and to a specified sheet?
 
Hi Belinda,
Besides opening the HTML file from Excel as already mentioned...

You can select the Table portion and copy (ctrl+c) then paste
(ctrl+v) it into Excel.

If you need a programming solution, I'm sure it would be more
difficult, but see what you get by recording a macro starting
before opening the file.
 
Back
Top