Full path name for the GetOpenFileName

[HunterN]

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

 

[Norie]

Nancy

The FileFilter argument is for filtering files.

If you want to use a particular directory try using ChDir.

ChDir myPath & "\Old Supps\"

 

[HunterN]

I sorry - but where do I put the change directory command?

ChDir myPath & "\Old Supps\"

Inside the GetOpenFilename or before I execute this Open Dialog box?

Nancy

 

[Norie]

Nancy

Put it before GetOpenFilename.

ChDir myPath & "\Old Supps\" 
 UF = Application.GetOpenFilename(FileFilter:="Text Files(*.txt),*.txt", _
Title:="Text Files to Open")

 

[HunterN]

I put in the code above the OpenFilename line, and it still doesn't change anything. It still opens up in My Documents area


Nancy

 

[Norie]

Nancy

Did you also include the code for setting the value of mypath?

Are you on a network?

 

[HunterN]

Yes to setting the code for myPath
It equals "H:\Public Test"


and Yes to am I on a network!

So does that matter?

Nancy