PDA

View Full Version : Extract table from website



swaggerbox
08-23-2020, 02:01 AM
Is there a way I can extract a table from a website thru VBA (and not web query). Sample URL is: https://www.chemicalbook.com/CASDetailList_0_EN.htm

I would like to extract the CAS, Product Name and MF to columns A, B and C of an excel workbook. Can anyone help me get started?