I'm attempting to write some code that will prompt the user to open a workbook from a sub folder via a file open dialog box.
Problem one is the file is burried away under several layers of sub folders so I'd like the dialog box to default to the sub sub folder level.
Problem two is these folders are on a networkdrive "\\NetWorkName\Folder\SubFolder\SubSubFolder\".
Would anyone have some ready made code to help me with this?
Thanks in advance for any help.
B
Are you asking for a type of "crawler" that will find the file given its name and a root directory, or do you already know the path on which the file resides? Are you looking for a navigation box like Windows Explorer uses?
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Found this : http://stackoverflow.com/questions/1...path-not-drive
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks