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?

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"Michael Wise" wrote:

>
> 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?
>
>
> --
> Michael Wise
> ------------------------------------------------------------------------
> Michael Wise's Profile: http://www.excelforum.com/member.php...fo&userid=6998
> View this thread: http://www.excelforum.com/showthread...hreadid=537812
>
>