I currently have a DIM field which contains the file name a user selects from an GetOpenFilename command. How can I store the path & filename selected by the user which is stored the w_currentFileName Dim field into a cell (say B28)?
w_currentFileName = Application.GetOpenFilename(filefilter:="Excel Files (*.xls), *.xls", Title:="Select CURRENT Behaviors mo-end file (see path T:\test\Behaviors_Pool(NewChart)...xls")
w_currentFileName = Application.GetOpenFilename(filefilter:="Excel Files (*.xls), *.xls", Title:="Select CURRENT Behaviors mo-end file (see path T:\test\Behaviors_Pool(NewChart)...xls")
Last edited: