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

replace "c:\outbox" with the directory you are interested in.
--
www.alignment-systems.com


"JackSchilder" wrote:


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


--
JackSchilder
------------------------------------------------------------------------
JackSchilder's Profile: http://www.excelforum.com/member.php...o&userid=31577
View this thread: http://www.excelforum.com/showthread...hreadid=529582