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...