+ Reply to Thread
Results 1 to 2 of 2

Text File Manipulation

  1. #1
    Registered User
    Join Date
    05-22-2008
    Posts
    18

    Text File Manipulation

    Hi,
    I have a question regarding reading and writing text files. I have text files which contain data results from a structural analysis program. The files vary in size according to the size of the problem and have a format similar to this

    intro lines
    intro lines
    intro lines
    0 1 2
    3 4 5
    6 7 8
    summary lines
    summary lines
    summary lines

    The way I import the data into excel at the moment is to delete all the intro and summary data from the text file, then open the file up with excel and paste it into my sheet that has the macro to process the data.

    I have been trying to find out the best method to automatically prepare and import the data. I have read that excel has some text file reading and writing capabilities. Would it be a viable option to use VBA to do this process or is it better to try and use another program ported with excel. Python maybe?

    Thanks,

    Regards Elbarto

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    You can use I/O commands in VBA.

    How do you determine intro lines and summary lines?
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1