Solved

find next and select

Posted on 2002-07-06
6
155 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
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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
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.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

770 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