html page to excel

[Suri]

Hi


I Have 1000 html sheets . I want to convert to One Excel Sheet. Any Solution is there Plz tellmee

 

[Hui]

Suri


There are a few ways to tackle this


1. Start a macro, import the file yourself and close the macro

Then put that inside a loop to open each file


2. There are a few utilities on the net which do batch transfers of file types.

Try googling: "Batch convert html to excel"

 

[kalpesh39]

Suri


There are a few ways to tackle this


1. Start a macro, import the file yourself and close the macro

Then put that inside a loop to open each file


2. There are a few utilities on the net which do batch transfers of file types.

Try googling: "Batch convert html to excel"

Sir HUI,

what if i want to select particular table from HTML file , & want to put in a Single workbook But in separate sheets?

Thanks

 

[Marc L]

Hi !

Easy if all files have exactly the same structure :
you just must select wanted table when you import from Web (Excel function)
as QueryTable in VBA, see samples in threads of appropriate forum
as here it is the Excel worksheet formulas forum …

As all you can do within Excel can be automatized, you just have to activate
Macro Recorder before to start and you will get your free own code !
​