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