| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to choose a folder
http://www.j-walk.com/ss/excel/tips/tip29.htm
Selecting a directory -- Regards, Tom Ogilvy "Ctech" wrote in message ... How can I get the user of a macro to choose a folder? The code I have now, opens a specific file. However I want the user to select a folder. I want this as the macro is to open all the files in the selected folder... My code now: Application.Workbooks.Open Filename:= _ "X:\Users\Shared\GENERAL\Christian S\05.10.28 - Budget packs - Capital expenditure - comments\BFR " & Mnumb & " bud v1.xls" _ , UpdateLinks:=0 -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=482149 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling pdf files from general folder to specific folder | Excel Discussion (Misc queries) | |||
| how can i change my default working folder to a networked folder? | Excel Discussion (Misc queries) | |||
| How to decide folder-depth or How to select more folders/subfolders (folder-tree) ? | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| ENTER DATE, CHOOSE WKSHEET, SAVE IN FOLDER | Excel Programming | |||
Threaded Mode
