Selecting a file by its location rather than its name

[woolls01]

I have a listbox and would like to use it to select a file from a known location, but I want to select by position as its name may change (example: if someone selects the first option in listbox then the first file within the folder d:\workpack is selected).

Thanks

[daniel aristidou]

I have a listbox and would like to use it to select a file from a known location, but I want to select by position as its name may change (example: if someone selects the first option in listbox then the first file within the folder d:\workpack is selected).

Thanks

Is the file the only file in the folder......ie location or is there a group of files in the known location

[woolls01]

There are about 8 files in the subfolder and there 'll always be the same number of options in the listbox

[Killer42]

I think you'll find that most if not all methods of finding the file will return them in alphabetical order by file name. So the idea of "position" may not be meaningful.

But if you're ok with that, then it's pretty simple. Just start picking through the files in the folder, and stop when you get to the 'nth' one.

[woolls01]

Yes but what code do i need to select the nth file?

[Killer42]

It might depend a bit on what version of VB you're using. But in any case, look up "FileSystemObject model" in the documentation. This will explain how to use FSO to go through the files in a folder.