macro possible?

[kate10123]

Hey guys!

It's been a while!

Quite a complicated question. I have a folder, within that folder are 5 html files and an excel file

Each html file has a table of data in it.

I need to be open to open the excel file from the folder and on opening, it pulls the data from each of the html files into 5 seperate sheets of the workbook.

Is this achievable with a macro?

I'd appreciate any help on how to accomplish this

 

[John_w]

Try a web query on each HTML file on a separate sheet. Record the manual steps with the Macro Recorder to generate the VBA code.