Hi all
I am using the following code to allow the user to select a file they wish to process:
strFileLocation = Application.GetOpenFilename(FileFilter, FilterIndex, Title)
that stores the path of the file into the variable.
what I would like is to store the actual filename, so that when it is open, I can then use the filename to switch between workbooks.
Can anyone tell me how I can store just the name?
(even if it is stripping the string after the last '\')
thanks in advance,
Matt
I am using the following code to allow the user to select a file they wish to process:
strFileLocation = Application.GetOpenFilename(FileFilter, FilterIndex, Title)
that stores the path of the file into the variable.
what I would like is to store the actual filename, so that when it is open, I can then use the filename to switch between workbooks.
Can anyone tell me how I can store just the name?
(even if it is stripping the string after the last '\')
thanks in advance,
Matt