Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Macro to Open File, Delete Contents, Save New File | Excel Discussion (Misc queries) | |||
Help with Open and Read txt file, please? | Excel Programming | |||
How to Open file as read only | Excel Programming | |||
Read Contents of text File into worksheet | Excel Programming | |||
File in use open read only | Excel Programming |