D3allamerican07
Board Regular
- Joined
- Jul 22, 2015
- Messages
- 101
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.
Thank you in advance!
Bill
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.
Code:
Set wb = Workbooks.Open(FileName:=objFile)Thank you in advance!
Bill
