How to read a filename as a string variable?

[Zoticos]

I’m having a problem in regards to comparing a string variable with a filename.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Here’s my sample.<o></o>
<o></o>
Textbox.text input is: “new york”<o></o>
My file name is: “C:\DATA\Location – New York.bmp”<o></o>
<o></o>
How can I read the filename as a string, and then compare the Textbox.text string with the filename?<o></o>
<o></o>
The compare needs to ignore the case and see if “new york” exist in the filename else exit sub.<o></o>
<o></o>
Thanks for any help!<o></o>

 

[bertie]

Try a variation of this:

[COLOR=darkblue]Private[/COLOR] [COLOR=darkblue]Sub[/COLOR] CommandButton1_Click()
   [COLOR=darkblue]Dim[/COLOR] sPath [COLOR=darkblue]As[/COLOR] [COLOR=darkblue]String[/COLOR]
   sPath = "C:\Data\Location - " & TextBox1.Value & ".bmp"
 
   [COLOR=darkblue]If[/COLOR] Dir(sPath) = "" [COLOR=darkblue]Then[/COLOR]
      MsgBox "File does not exist!"
   [COLOR=darkblue]Else[/COLOR]
      MsgBox "File exists!"
   [COLOR=darkblue]End[/COLOR] [COLOR=darkblue]If[/COLOR]
End [COLOR=darkblue]Sub[/COLOR]

 

[Norie]

You can use InStr to see if one string is within another.

Dim strFilename As String
Dim strTxtBox As String
Dim pos As Long
    strTxtBox = "New york"
    
    strFilename = "C:\DATA\Location – New York.bmp"

    pos = InStrRev(strFilename, strTxtBox, , vbTextCompare)
    
    MsgBox pos

 

[Zoticos]

Thanks so much for your help! I was able to use your sample.

James