Opening folder with VBA. One Sub works, one Sub doesn't...

[jmpatrick]

Good morning.

I have a variation of this code I use under command buttons on two userforms. It opens a folder based on a path specified in a text box on the userforms.

This works correctly opening the desired folder:

Private Sub Reactivate_OPEN_Click()
Dim FolderPath As String
FolderPath = Me.Reactivate_Sub_Full_Name.Value
Call Shell("explorer.exe " & FolderPath, vbMaximizedFocus)
End Sub

Using almost the same code on another userform opens an Explorer window to my Documents folder instead of the desired folder:

Private Sub cmdOpenFolder_Click()
Dim FolderPath As String
FolderPath = Me.SE_SubLotFolderPath.Value
Call Shell("explorer.exe " & FolderPath, vbMaximizedFocus)
End Sub

Not sure what I'm doing wrong here.

 

[Candyman8019]

Stab in the dark...it looks like SE_SubLotFolderPath may not have a valid path.
before your 'call' command try add

msgbox folderpath

to see 1. if the value exists and 2. to confirm if the value is valid, ie not missing any '\' at the end, etc.

 

[jmpatrick]

Stab in the dark...it looks like SE_SubLotFolderPath may not have a valid path.
before your 'call' command try add

msgbox folderpath

to see 1. if the value exists and 2. to confirm if the value is valid, ie not missing any '\' at the end, etc.

You stirred my brain! I had / instead of \. Once I fixed that it opened fine. Thanks.