How do I Make a macro in exel to just open the "open" screen?

[JackSchilder]

Topic title may be a bit confusing. I'll try to explain

I want a macro which opens a certains directory which contains severa
files.. The user then may pick the file he wants himself.

Hope anyone can help. Its probably very simple but i am not a rea
excel vbasic guru

Thanks in advanc

 

[John.Greenan]

Sub whatever()
Application.Dialogs(xlDialogOpen).Show "c:\outbox"
End Sub

replace "c:\outbox" with the directory you are interested in.

 

[JackSchilder]

Thanks a lot