+ Reply to Thread
Results 1 to 3 of 3

Search and stop

  1. #1
    Registered User
    Join Date
    11-26-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Search and stop

    Hello guys, I'm very new to VBA and I would like to ask a question

    I have a text file and i want to search a certain string. then after that i want to stop the process after its found another certain string.

    I have provided the sample text file..

    Firstly, I would like to find the first textline which is SIFI and I would like it to read all the next textline until it reach the next SIFI. Then, I would like the process to stop if it found the next SIFI.

    I'm using MS Excel 2003

    May you all help me...
    Attached Files Attached Files
    Last edited by djmal; 11-26-2010 at 05:20 AM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Search and stop

    What does this have to do with Excel? And what exactly are you doing, apart from looking for a string? Once you've found the string don't you want to do something?

  3. #3
    Registered User
    Join Date
    11-26-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Search and stop

    I'm sorry I don't elaborate more..
    after the string is found, i would like it to copy the word into excel...

+ 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