View Single Post
Old 01-04-2012, 12:48 PM
tpcervelo tpcervelo is offline Windows XP Office 2003
Join Date: Sep 2010
Posts: 5
tpcervelo is on a distinguished road
Default 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?
Reply With Quote