create "file browse" pop up box? (newbie question)

[ryansupak]

is there a way to utilize VB to prompt the user for a source file path/name and a destination file path/name? (ideally, the user would be able to "Browse..." from within the box.)

thanks in advance,
rs

 

[Tim Francis-Wright]

On 2002-04-24 09:05, ryansupak wrote:
is there a way to utilize VB to prompt the user for a source file path/name and a destination file path/name? (ideally, the user would be able to "Browse..." from within the box.)

thanks in advance,
rs

try something like this:

Create a CommandButton and use this sort of code:

Private Sub CommandButton1_Click()
Dim Filter As String, Caption As String, SelectedFile As Variant

Filter = "Fountains (*.xls),*.xls"
Caption = "Please Select the Fountain of Youth"
SelectedFile = Application.GetOpenFilename(Filter, , Caption)
If SelectedFile = False Then Exit Sub

Workbooks.Open SelectedFile

Set SelectedFile = Nothing
End Sub