View Single Post
Old Jul 22, 2004 | 06:31 PM
  #4  
_Ben_'s Avatar
_Ben_
I'm Finding My Feet Here Now
 
Joined: Jun 2003
Posts: 148
Likes: 0
Default

Or, its a billion times easier to create a new module in word/excel whatever and paste the following as a macro:

Option Explicit

Sub test()
Dim davesFolder As FileDialog
Set davesFolder = Application.FileDialog(msoFileDialogFolderPicker)
davesFolder.InitialFileName = "C:\daves_useful_folder\"
davesFolder.Show
End Sub

Cheers.
Reply