Import data from multiple html files into one excel worksheet

[westconn1]

instead of using dir to get the filename you could try like

x = 1
fname = mypath & "file" & x & ".htm"
do until fname = ""

    ''''all your code for each file
    x= x + 1
    fname = mypath & "file" & x & ".htm"
loop

if any files are missing from the number sequence, it will stop at that point

Can we set the account column

set column to text, has to be done before the data is put in the cell

range("d1").entirecolumn.numberformat = "@"

change the D to whatever column you want

As mentioned in my earlier comment, for few page line items the data is not available in the date column so instead of keeping that cell blank it imports the next column data in the date column

as there are no columns at all in the html code, it is hard to change the way excel converts text to columns, possibly the easiest way would be, after import, to check where the last column is empty then insert the additional cell for those rows, but i am not sure how accurate that would be, and it would probably take quite some time to run, post some sample data of rows that do not have date and i will see if it is possible to fix the raw data, before importing, similar to the fix for internal