HTML files convert all cells to text before opening (dropped leading zeros)

[D3allamerican07]

I have a package of html files I open in excel. Unfortunately, opening the file converts the cells to 'General' and drops leading zeros. I have a code to loop through the package, open the files, and copy that sheet to a workbook.

Is there a way to open the file with the columns already as 'Text' to prevent losing those leading zeros or open that file in a sheet with columns already formatted?


Also, once open, it is already to late to use Text-To-Columns. The html file is not delimited either.

Set wb = Workbooks.Open(FileName:=objFile)

Thank you in advance!
Bill