Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Browse to select a folder
Excel 2003-2007
An OP posted a problem and I realized that there was one thing I needed to know before I could help him. What is the code to allow the user to select a folder? The result must be the full path to that folder. Note: That path will not be the path to ThisWorkbook. Thanks for your time. Otto |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Browse to select a folder
See a example in the macro on this page
http://www.rondebruin.nl/csv.htm 'Browse to the folder with CSV files Set oApp = CreateObject("Shell.Application") Set oFolder = oApp.BrowseForFolder(0, "Select folder with CSV files", 512) If Not oFolder Is Nothing Then foldername = oFolder.Self.Path If Right(foldername, 1) < "\" Then foldername = foldername & "\" End If -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Otto Moehrbach" wrote in message ... Excel 2003-2007 An OP posted a problem and I realized that there was one thing I needed to know before I could help him. What is the code to allow the user to select a folder? The result must be the full path to that folder. Note: That path will not be the path to ThisWorkbook. Thanks for your time. Otto |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Browse to select a folder
I have code and a downloadable module at
http://www.cpearson.com/excel/BrowseFolder.aspx that displays the standard Windows Browse Folder dialog. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Tue, 18 May 2010 13:10:27 -0400, "Otto Moehrbach" wrote: Excel 2003-2007 An OP posted a problem and I realized that there was one thing I needed to know before I could help him. What is the code to allow the user to select a folder? The result must be the full path to that folder. Note: That path will not be the path to ThisWorkbook. Thanks for your time. Otto |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Browse to select a folder
Thanks guys. Otto
"Chip Pearson" wrote in message ... I have code and a downloadable module at http://www.cpearson.com/excel/BrowseFolder.aspx that displays the standard Windows Browse Folder dialog. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Tue, 18 May 2010 13:10:27 -0400, "Otto Moehrbach" wrote: Excel 2003-2007 An OP posted a problem and I realized that there was one thing I needed to know before I could help him. What is the code to allow the user to select a folder? The result must be the full path to that folder. Note: That path will not be the path to ThisWorkbook. Thanks for your time. Otto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Browse for folder - not selecting folder | Excel Programming | |||
Browse for folder - not selecting folder | Excel Programming | |||
Browse for folder - not selecting folder | Excel Programming | |||
Browse for folder | Excel Programming | |||
Browse for folder | Excel Programming |