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