Open a folder with Code

[Leesha]

Hi,
I need to give users a the ability to easily find the folder where their backend tables are stored so they can copy them to back them up. I was using a hyperlink on a button but it doesn't work consistently. Is there a way to open a folder using code instead of a hyperlink?
Thanks,
Leesha

[HansV]

Try

Code: Select all

    Dim strFolder As String
    strFolder = "..." ' folder path
    Shell "Explorer """ & strFolder & """", vbNormalFocus

[Leesha]

Thanks Hans! That worked perfectly!