View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Striker Striker is offline
external usenet poster
 
Posts: 55
Default Open a file and read contents

I need to try to open a text file that is 500 bytes per record, that is each
record is a dump from a mainframe and is 500 spaces long with no delimiters.
I know where each position of data will be, for instance in position 30 thru
34 is the zip code, 35 thru 38 is the 4 zip code extension 38 thru 53 is the
first name, etc.

So I need to transfer this data to an excel spreadsheet. I thought I could
loop through the file line by line extracting the data I wanted and placing
in variables, then moving to the spreadsheet and pasting those variables.
Or maybe just insert a comma in the text file to be used as a delimiter and
import the file into a template with the headers already set up. I'm
looking for some direction as to which way to go. Once I can decide that,
then I will be able to struggle thru the code with the help of this board.

In any case how can I open a file for reading, or if adding a comma editing.
Lets assume the text file has an absolute path of C:\Temp\TextFle.txt

Thanks in Advance