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

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

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

Thanks in advance