mferrisi
01-16-2008, 04:13 PM
I am attemping to bring in the filename and location of file that the user selectes from a FileDialog box.
When I use the following code,
Application.FileDialog(msoFileDialogFilePicker).Show
Filename = Application.FileDialog(msoFileDialogFilePicker).InitialFileName
Filename is equal to the name of the first folder.
ie the file selected is w:\YearNum\Inventory\Person\test.xls
but this code returns only w:\YearNum.
What do I need to do to get the entire string?
Thank you,
M
When I use the following code,
Application.FileDialog(msoFileDialogFilePicker).Show
Filename = Application.FileDialog(msoFileDialogFilePicker).InitialFileName
Filename is equal to the name of the first folder.
ie the file selected is w:\YearNum\Inventory\Person\test.xls
but this code returns only w:\YearNum.
What do I need to do to get the entire string?
Thank you,
M