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

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

--
JackSchilde
-----------------------------------------------------------------------
JackSchilder's Profile: http://www.excelforum.com/member.php...fo&userid=3157
View this thread: http://www.excelforum.com/showthread.php?threadid=52958

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

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

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

Thanks a lot :):):cool:


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