HunterN
Active Member
- Joined
- Mar 19, 2002
- Messages
- 479
Hi,
I know how to use the GetOpenFilename that displays a dialog box for
the user to choose a file to open. What I want to know is this: can you
specify the full path so that the dialog box opens only in a certain directory?
This is what I have, but it does not seem to work. It only opens the My Documents directory.
myPath = ThisWorkbook.Path
UF = Application.GetOpenFilename(FileFilter:=myPath & "\Old Supps\" & "Text Files(*.txt),*.txt", _
Title:="Text Files to Open")
Thanks,
Nancy
I know how to use the GetOpenFilename that displays a dialog box for
the user to choose a file to open. What I want to know is this: can you
specify the full path so that the dialog box opens only in a certain directory?
This is what I have, but it does not seem to work. It only opens the My Documents directory.
myPath = ThisWorkbook.Path
UF = Application.GetOpenFilename(FileFilter:=myPath & "\Old Supps\" & "Text Files(*.txt),*.txt", _
Title:="Text Files to Open")
Thanks,
Nancy