Re: Import data from multiple html files into one excel worksheet
you should use vbnullstring, which as almost the same as "", either would do, you should then have empty cells
i do not know why you can not replace the ~ character, seems to be just one of those things, i just chose that character at random, any other character should do the same job and most should be replaceable, try x instead
Re: Import data from multiple html files into one excel worksheet
Ok. but I changed it in the script itself and it works fine. Thanks a lot :)
Code:
Close 1
htm = Replace(htm, " internal", "_internal", , , vbTextCompare)
htm = Replace(htm, Space(9), " Null ")
htm = replace(htm, "</SPAN", " " & fname & "</SPAN")
doc.body.innerHTML = htm
Re: Import data from multiple html files into one excel worksheet
Hi coulld you please share the complete working code ?
