Read text Report file with VBA and write parsed fields to Excel workbook
I have a VBA program that reads a comma delimited text file of a Report.
The VBA excludes all report headers, column names, spaces and line feeds leaving only an 80 character string for each report data line.
It then parses that string into 8 fields which it then writes out as a comma delimited text file. I then manually import that text file into Excel.
Does anyone know of a way that this can be automated.
Such as, read the Report file with the VBA code and write the 8 fields into cells 1-8 for each line/row of the report?
|