LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
RWN RWN is offline
external usenet poster
 
Posts: 104
Default Selecting an initial directory

xl2kPro
I'm looking for a "short" function that will allow the user to select an initial
directory.
My utility will then loop through the directory and subdirectories picking off specific
filenames (common extensions).
I have no problem with the second part (using the "Application.FileSearch") but cannot
find a function that will allow a box to popup for the initial directory selection.
I know I can "Slice/Dice" the directory name from a "GetOpenFileNames" function but that
requires a file to exist in the directory, which may/will not always be the case.
I could write my own routine to do this but was hoping for an "easier" way-in the deep
dark (*very*) distant past I remember having to do this via an API call.

Any suggestions, I've reached the end of the object browser!
--
Regards;
Rob
------------------------------------------------------------------------


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove middle initial from "first name middle initial" Justin F. Excel Discussion (Misc queries) 15 September 26th 05 06:13 PM
Selecting a Directory Nigel Excel Programming 2 April 30th 05 01:57 PM
Creating a macro that lists directory names within a directory.... Andy Excel Programming 4 November 28th 04 06:13 AM
Selecting a directory from a form in excel ennui Excel Programming 6 April 2nd 04 01:47 AM
Directory "Locked" when selecting multiple files using GetOpenFilename esbey Excel Programming 1 March 4th 04 04:29 AM


All times are GMT +1. The time now is 06:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"