Want to Open Windows Explorer With an Excel Macro

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
 
S

ste

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro on all files in a specific folder 3
Open Windows Explorer from Excel and select specific file 10
Windows Explorer 4
Macro for all Excel Workbooks to print to PDF 2
Open Multiple Microsoft Office Documents in Alphabetical Order from Windows Explorer. 0
Unwanted workbooks on startup 2
How to open another program and file? 3
Open Word file with Excel VBA 2

Top