Import data from multiple html files into one excel worksheet

[abhay_547]

Great. Its working as expected

The only issue is that when post running the macro when I try to replace the "~" with Null it doesn't work. It says Microsoft Excel cannot find any data to replace.

Another thing, while data is getting imported after the last column, can we input the file number for e.g. the macro has imported File256.htm then in column P can we enter number 256 or even the file256.htm text against each row which is imported from that file, just to identify the rows that which is imported from which file.