Search Function for External Files

[Cjtman]

Hi all,
I am creating a button on a form that opens a folder on our local network. This is what I currently have:

Private Sub Command92_Click()
Application.FollowHyperlink "N:\_BMP CAD\5000"
End Sub

I would like to add a file name to the end of this address, something like this:

Private Sub Command92_Click()
Application.FollowHyperlink "N:\_BMP CAD\5000\examplefile.prt"
End Sub

The catch is that I would like this file name to be dynamically pulled from a text box. Below is something like how I think this should look. The syntax is completely wrong, but it should get the point across.

Private Sub Command92_Click()
Application.FollowHyperlink "N:\_BMP CAD\5000\*[SearchBox]*"
End Sub

I would greatly appreciate more experienced input on this!

[ranman256]

this function already exists in the file explorer, top right corner box.

[Cjtman]

Could you expound on that statement? I didn't catch what you are referring to.

[ssanfu]

Maybe try

Private Sub Command92_Click()
    Dim default
    Dim Title As String
    Dim prompt As String

    prompt = "Enter a file name"
    Title = "Get file name"
    Application.FollowHyperlink "N:\_BMP CAD\5000\*" & InputBox(prompt, Title, default) & "*"
End Sub

I NEVER use the InputBox function. I would have an unbound text box control on a form and get the value from the text box. Better yet, I would have a combo box so the file name could be selected first.

[Micron]

but the value is to come from a form textbox, no?

Application.FollowHyperlink "N:\_BMP CAD\5000\" & Me.txtNameOfTextbox

If the textbox provides an invalid value, you'll generate an error, which you're not trying to trap. Maybe you should use the msoFileDialogFilePicker control and forget the textbox idea.

[Cjtman]

Thanks to all of you for your quick replies! Are there any suggestions about how I could open File explorer with a button and fill the search from the textbox content on the form?
(BTW, I am not an experienced programmer- just somewhat basic stuff)

[Micron]

Are there any suggestions about how I could open File explorer with a button...

That was covered in post 5.

Maybe you should use the msoFileDialogFilePicker control

There are a gazillion sites with code solutions you can copy rather than us copying from anywhere and reposting it here. All you need to do is search. There is a folder picker and file picker version, so know what it is you want to navigate to - folder or file - before you start copying code.

You also have been shown how to get the data from the text box and concatenate it to the beginning of your file path. You can use this information in your version of the code to pass the starting point to the picker dialog if you want to.