![]() ![]() sFullPath = Application.GetOpenFileName() If you allow multiple files to be selected you can use the IsArray() function to check if multiple files were selected.Īll the arguments are optional. MultiSelect - Determines if the user can select multiple files. Not required if there is only one filter provided.īuttonText - This argument is not used in Excel for Windows. The default is "User (*.*), *.*"įilterIndex - This specifies which file filter is the default. This argument consists of pairs of the file filter display text followed by the wildcard file filter specification. sFullPath = Application.GetOpenFileName(FileFilter, _įileFilter - This determines the types of files that will be displayed in the Files Of Type drop-down list. This method will return a string value specifying the path and filename that was selected. This method displays the Open dialog box but will not actually open the file. To select a file you should use the Application.FileDialog - FilePicker method. ![]() This should not be used but is still available for backwards compatibility. This method can be used to obtain a valid filename and its full path. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |