Select a file out of a list of files

[Michael Wise]

Using the filesearch object in the main file i'm wanting to be able to
select a single file from the list filesearch returns to copy its data
into the main file. Any suggestions?

 

[Guest]

put up a userform with the results of the search in a combobox

with fs
.. . .
..Execute
for i = 1 to .foundfiles.count
userform1.combobox1.addItem .foundfiles(i)
Next
End With

Userform1.Show

then in the click event of the combobox

With userform1.Combobox1
fname = .list(listindex)
End With

workbooks.open fname