hi,
would like a button that opens he folder created earlier by a procedure.
My question is what is the VBA to open a folder, im sure its a easy question for you guys!

Cheers

What do you mean "open a folder?"


mmcdonal

Assuming you mean to open an Explorer window at the given folder location... try something like:

Call Shell("explorer.exe X:\Location\etc", vbNormalFocus)

cheers how can i call the folder from a string?

Do you mean to put a file in the folder or to physically open the folder to display it?

Jonni,

What do you mean by: "... call the folder from a string"?

sorry i was not sure how to formulate my question (obviously)
its working now,

    Dim strShortcut As String
    strShortcut = Me.txtShortcut

    Call Shell("explorer.exe " & strShortcut, vbNormalFocus)

i had problems where i did not leave a space between .exe and the " but its working now, cheers for taking time to ponder my query
Jonni