Simple Browse Question

[brsawvel]

Hello, How do I create a cmd button to open a browse and enters the path of the file I select in the browse into a txtbox on the same form as the browse button?

 

[ajetrumpet]

put this behind the click event of the button

Sub FOO()

Dim varitem As Variant

      With Application.FileDialog(msoFileDialogFilePicker)

         With .Filters
           .Clear
           .Add "All Files", "*.*"
         End With

             .AllowMultiSelect = False
             .InitialFileName = [color=red]FULL PATH OF THE SOURCE DIRECTORY YOU WANT TO OPEN (IN QUOTE MARKS)[/color]
             .InitialView = msoFileDialogViewDetails

                    If .Show Then

                       For Each varitem In .SelectedItems
                          me.[color=red]YourTextBoxName[/color] = Varitem
                       Next varitem

                    End If

      End With

End Sub

 

[HiTechCoach]

Here is a solution the calls the standard Windows Dialog:

Call the standard Windows File Open/Save dialog box

Hope this helps ...

 

[ajetrumpet]

BTW, good to see you again BrSawvel. Long time no see, huh?