Select a file out of a list of files
 

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

Select a file out of a list of files
 

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