Using user selected folder as variable

[ramsola]

Hi,

I am looking for a way to have the user select a folder where multiple files reside and have this filepath somehow recorded as a value in the code which will be refered to at various locations within the code. I need this because the same file structure will be in each folder but the folder name/filepath will change.

Can anyone help, please?

Ramsola

 

[Andrew Fergus]

Hi Ramsola

Something like this should work:

Dim FileLocation As String

With Application.FileDialog(msoFileDialogOpen)
    .AllowMultiSelect = False
    .Show
    
    If .SelectedItems.Count = 0 Then
        'user pressed cancel
        MsgBox "you pressed cancel"
    Else
        FileLocation = .SelectedItems(1)
        'remove the line below once you are happy testing this
        MsgBox FileLocation
    End If
    
End With

HTH, Andrew

P.S. While inside the With section, if you press the period key (.) you will see a number of other options appear - for example, you can set the dialogue box title, set a filter to only show certain types of files and so forth.

 

[ramsola]

Problem Solved!!

Many thanks for the reply, exactly what I wanted!!