OpenFile Dialog Box

by Linda Quinn

Close Window        Print Page



The following code can be used to display an OpenFile dialog box.

This allows the user to select the workbook to be processed.




Application.GetOpenFileName will display an open dialog box
fileToOpen is a variable that will contain the name and path of the selected file.
If a file was not selected, fileToOpen will be false.
DIR(fileToOpen) will return the file name portion of the file in filex.

FileFilters describe which files are displayed in the Open File dialog


Examples of Filter Statements











Copyright © 2006-2016, LQSystems,Inc. All rights reserved.