Check out GetOpenFileName in VBE help.

I think you can use the example to use the cell contents as the filenames.
Than just loop through all the cells.

Or you could just use workbook.open or Open.

--
steveB

Remove "AYN" from email to respond
"Aonghus" wrote in message
...
Hi,
I have a userform in a master file that inputs a list of .xl file names
into
a column(K) in a worksheet(Selection Properties), the list could contain
any
number of .xl file names( from K2 to column("K").end(xldown)). What I want
to
do is to open all these files, copy all information on sheet 1 in these
files
and paste all into one worksheet in the current master excel file. I am
having difficulty with the code for opening the possible range of values
in
column "K".
Thanks for your time