Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Make a macro in exel to just open the "open" screen?
Thanks a lot :):) -- JackSchilder ------------------------------------------------------------------------ JackSchilder's Profile: http://www.excelforum.com/member.php...o&userid=31577 View this thread: http://www.excelforum.com/showthread...hreadid=529582 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"File Open" box Excel is full screen, how can I size it down? | Excel Discussion (Misc queries) | |||
Spreadsheet will no longer "open" on the screen | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
How do I set up "Add to Favourites" icon in Open screen? | Excel Discussion (Misc queries) |