saving txt as xls with autofit in VBA
Posted on 2001-07-23
The below is an attempt to save a tab-delimited text file into an Excel spreadsheet, with all columns auto-fitted. The AutoFit doesn't work, and I keep getting prompted to save changes, which won't cut it in a batch environment. Any suggestions?
Dim Excel As New Excel.Application