Userform that allows user to select an open file?

Originally Posted by Kaper

wouldnt it be wise just to open the file with Open dialog?
Of course you can browse workbooks collection (contains all open wbks in this instance of excel).
something like

dim wbk as excel.workbook
for each wbk in application.workbooks
  if wbk.name <> thisworkbook.name then
  ' populate some control in Userform like list.add or something
   ' or check some characteristic sign that "this is the file" an if "it is -> exit for
  end if
next wbk

Thanks! That would work too. Is there a way to open a file and then have it copy in data even if I don't know the name of that document (since it will change every day)? I just want to push a button, and have it copy in data. So whatever method is the easiest works.