Want to Open Windows Explorer With an Excel Macro

  • Thread starter Thread starter johan
  • Start date Start date
J

johan

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
 
Back
Top