Hi all
I am not sure if this is possible but am hoping someone can help.
Currently I have a Combo box that shows a list of filenames stored in
specific location and allows the user to open the file.
This is based of a formula which is run on a hidden Excel sheet.
I need to compile the data on a number of the files, but don't reall
want to have to open them all up copy the data, etc etc.
The trickey part is that I need to be able to select which of the file
that I want to open by the contents of the filename itself. They ar
Always..... \"Username"\"Team Name"\"Month"
So all are always different. I need to be able, for example to open al
of a specific team name for the month of june, take the information an
compile it on a master sheet.
Sorry this is long winded and I hope I have explained it well enough t
know if it is possible
Thank
--
Message posted from
http://www.ExcelForum.com