Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering File names
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Excel file get error with file names that have spaces in the | Setting up and Configuration of Excel | |||
Filtering Duplicate Course Names Using an Existing Formula | Excel Worksheet Functions | |||
EXCEL97 FILE NAMES TRUNCATED TO THE FIRST LETTER IN THE FILE NAME | New Users to Excel | |||
How- seperate a combined list by filtering out first list of names | Excel Worksheet Functions | |||
Filtering Names By Date | Excel Programming |