LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Macro to Open File, Delete Contents, Save New File Flintstone[_2_] Excel Discussion (Misc queries) 2 February 1st 10 11:25 PM
Help with Open and Read txt file, please? Ed Excel Programming 1 April 28th 05 06:12 AM
How to Open file as read only Helen Excel Programming 1 January 24th 05 02:45 PM
Read Contents of text File into worksheet Steve Roberts Excel Programming 1 November 28th 04 04:57 PM
File in use open read only jeffP Excel Programming 0 August 21st 04 06:37 PM


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"