GetFilePath$ Function

Syntax:
GetFilePath[$]([DefName$], [DefExt$], [DefDir$], _
[Title$], [Option])
Group: User Input
Description:
Put up a dialog box and get a file path from the user. The returned string is a complete path and file name. If the cancel button is pressed then a null string is returned.
Parameter Description

DefName$ Set the initial File Name in the to this string value. If this is omitted then *.DefExt$ is used.
DefExt$ Initially show files whose extension matches this string value. (Multiple extensions can be specified by using ";" as the separator.) If this is omitted then * is used.
DefDir$ This string value is the initial directory. If this is omitted then the current directory is used.
Title$ This string value is the title of the dialog. If this is omitted then ''Open" is used.
Option This numeric value determines the file selection options. If this is omitted then zero is used. See table below.
Option Effect

0 Only allow the user to select a file that exists.
  1. Confirm creation when the user selects a file that does not exist.
  2. Allow the user to select any file whether it exists or not.
  3. Confirm overwrite when the user selects a file that exists.
+4 Selecting a different directory changes the application's current directory.
Example:

Sub Main
Debug.Print GetFilePath$()
End Sub