Folder Buttons

[dancaw]

Hi,

I Have a folder location field which stores the folder location path of a project.

at moment I'm having to Paste the file path in manually.

I would Like a Select File Button and Open Store File Path Button

FieldName: "FolderLocation"
TxtBox: "fld_folderlocation"

Kind Regards



Dan

[kd2017]

First link I found from a Google search for 'vba directory dialog box': https://wellsr.com/vba/2016/excel/vb...gFolderPicker/

Let us know if this works for you.

[Micron]

If you want the file path, you don't want the folder picker, you want the file picker. I didn't see that on that link.
Google ms Access File Picker or perhaps start with

https://docs.microsoft.com/en-us/off...ice.filedialog

[dancaw]

If you want the file path, you don't want the folder picker, you want the file picker. I didn't see that on that link.
Google ms Access File Picker or perhaps start with

https://docs.microsoft.com/en-us/off...ice.filedialog

Hi thank you for Link:

I've managed to get it Selecting file path link, though it seems to save the Previous top level

Used the following code:

Private Sub cmdHyperlink_Click()
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFolderPicker)
With fd.AllowMultiSelect = False
if .Show Then    Me.FolderLocation.Value = .InitialFileName   
End If    
End With    
End Sub

No Sure if im Missing something

If i select Z:\Test\Test2

it stores

Z:\Test\

SO i have to select

Z:\Test\Test2\Test3

then saves as

Z:\Test\Test2\

still not worked out to create button to open "Z:\Test\Test2"

Regards

Dan

[Micron]

Hmm, the link I gave you had code for the file picker? But you used...
(msoFileDialogFolderPicker)

EDIT - that is not how your code is really laid out? If so, you should be getting errors.

[kd2017]

Try

    Dim fd As FileDialog
    Set fd = Application.FileDialog(msoFileDialogFolderPicker)
    With fd
        .AllowMultiSelect = False
        If .Show Then
            Me.fld_folderlocation = .SelectedItems(1)
        End If
    End With

[Welshgasman]

You need the folder picker if you are trying to save a folder path, and the file picker if you want to store a filepath.?

You might want to add a \ to the folder path if you expect to add a filename to it all the time?

The Folder Link worked fine for me?

[dancaw]

Thanks Kd2017

Works Like I Charm

also Thank you Micron for your assistance

[Micron]

You need the folder picker if you are trying to save a folder path, and the file picker if you want to store a filepath.?

I'm with you (and I already pointed this out). I guess what threw me is
"at moment I'm having to Paste the file path in manually."

Seems it was the folder path after all.