FileDialog assistance needed... [modified]

new_phoenix

Instead of parsing through a string path representing a directory and a file name in order to only record the directory name, I decided to use the Common Dialog known as FileDialog. However, I am not certain how to retrieve the results from the File Dialog. Here is what I have so far:

    Set dlgSaveAs = Application.FileDialog(msoFileDialogFolderPicker)
    dlgSaveDirectory.Show
    txtOutputFilePath.SetFocus
    txtOutputFilePath.Text = dlgSaveDirectory.Item

For some reason, I do not get the dropdown list indicating a value for the dlgSaveDirectory. Why can't I see the drop down list? The value that I get on the last line is: "FileDialog(msoFileDialogFolderPicker)" which is assigned to the txtOutputFilePath.Text. -- modified at 13:36 Friday 2nd November, 2007

pmarfleet

You've asked your question in the wrong forum. This forum is for SQL/database related questions.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush