I was recently asked to repair a webquery which had gone bad. The company controlling the website had changed the layout of the content. I decided to extract the data from the website into excel using VBA and a call on the HTML tables inside of the website itself. Obviously this technique works best where there are dedicated tables on a website. It does not discriminate as all data from the page is imported but with some smart manipulation you can inject some VBA to extract the relevant tables into a fresh worksheet.

Tags Import, Web, Data, Excel, Spreadsheet, vba