Using call shell to open a specified folder

[JonniP]

Hi
Am using

Call Shell("explorer.exe c:\", vbNormalFocus)

this works fine however i have the folder location stored in a txt field and would like the button to retrieve that location

Private Sub cmdShortcut_Click()
    Dim strShortcut As String
    strShortcut = Me.txtShortcut
 
    Call Shell("explorer.exe" & strShortcut, vbNormalFocus)
End Sub

tried this but not working, says path not found although copy pasting the path works.
I tried to use hyperlinks and they didnt work either.
any ideas greatly appreciated. j

[JonniP]

just to clarify the path i copy and paste is the one in "txtshortcut"

[ADezii]

Hi
Am using

Call Shell("explorer.exe c:\", vbNormalFocus)

this works fine however i have the folder location stored in a txt field and would like the button to retrieve that location

Private Sub cmdShortcut_Click()
    Dim strShortcut As String
    strShortcut = Me.txtShortcut
 
    Call Shell("explorer.exe" & strShortcut, vbNormalFocus)
End Sub

tried this but not working, says path not found although copy pasting the path works.
I tried to use hyperlinks and they didnt work either.
any ideas greatly appreciated. j

This will work fine, you simply needed a space after explorer.exe:

Dim retVal
retVal = Shell("explorer.exe " & Me![txtShortcut], vbNormalFocus)

[JonniP]

Cheers! i feel so stupid now!
Thanks again

[NeoPa]

LMAO.
But we've all done that Jonni.
The important thing is that you're sorted :)