View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ste ste is offline
external usenet poster
 
Posts: 18
Default Want to Open Windows Explorer With an Excel Macro

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