Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

find next and select

Posted on 2002-07-06
6
Medium Priority
?
160 Views
Last Modified: 2012-05-04
I am using a macro program which accommodates snippets of code. In order to speed up my process I need the code which does exactly what "Find" does in Notepad.

Searching from the cursor location. I would like to hard code the word to search for and the direction 'up or down' and leave the found word selected in notepad.

Thanks
0
Comment
Question by:pantoner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 3

Expert Comment

by:SirNick
ID: 7134153
Hello pantoner

The following links should point you in the right direction.

Find string in text file
http://www.freevbcode.com/ShowCode.Asp?ID=2740

Read a text file into a Rich text box and find string
http://www.freevbcode.com/ShowCode.Asp?ID=2524

Find/Replace dialog box demo
http://www.freevbcode.com/ShowCode.Asp?ID=3304

If the above doesn't help then do a search at:

http://www.planetsourcecode.com
0
 

Author Comment

by:pantoner
ID: 7134183
This is what I have so far. But instead of the code giving a msg box that says "found" I need it to select the word. Also I need to be able to search for the word up or down from where the cursor is currently located in the document.

Sub Main
Dim strTemp As String
Dim txtFind As String
txtFind = "function"  'word to find
    FileName = "c:\test.txt"
    If Dir(FileName) <> "" Then
        Open FileName For Input As 1
        While Not EOF(1)
            Line Input #1, strTemp
            txtFile = txtFile & strTemp & vbCrLf
        Wend
                If InStr(txtFile, txtFind) <> 0 Then
             MsgBox "found"
             'code to do what you want if text found
        Else
            MsgBox "Not found"
             'code to do what you want if text not found
        End If
        Close #1
    Else
        MsgBox "File not found"  'if the text file is not found
    End If
End Sub
0
 
LVL 2

Expert Comment

by:yongyih
ID: 7134345
May be you can use line number in VB.

line is a Read-only property that returns the current line number in a TextStream file.

Syntax

object.Line

The object is always the name of a TextStream object.

Remarks

After a file is initially opened and before anything is written, Line is equal to 1.


To search up or down, may be u just increase or decrease the line number..

hope this can help, good luck. ^_^
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 2

Expert Comment

by:yongyih
ID: 7134352
sorry, the property is read only, i think you cannot set the line value directly.

but you can store the line value for later use.

0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7990787
Hi pantoner,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Refund points and save as a 0-pt PAQ.

pantoner, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
0
 

Accepted Solution

by:
SpideyMod earned 0 total points
ID: 8053121
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question