Dear all,

With a button I want to open Windows Explorer in a specific folder with
an Excel macro.
For example : I want to open Windows Explorer and show me the folder
C:\Apps.

Can somebody help me (please) with a complete code.

Regards,
Johan

Hi Johan,

this is just a sample and needs some edit but it works

Function OpenDWG() As String
Dim F As FileDialog
Set F = Application.FileDialog(msoFileDialogOpen)
Dim Fdf As FileDialogFilter
With F
.Filters.Clear
.Filters.Add "ACAD file", "*.dwg"
If .Show = -1 Then
OpenDWG = F.SelectedItems(1)
Else
End If
End With

End Function

shell "explorer C:\Apps"


--
HTH

Bob Phillips

"johan" wrote in message
oups.com...
Dear all,

With a button I want to open Windows Explorer in a specific folder with
an Excel macro.
For example : I want to open Windows Explorer and show me the folder
C:\Apps.

Can somebody help me (please) with a complete code.

Regards,
Johan