Good day all. Excel 2007. XP Pro.
Is there a way to have all available excel files in a particular folder
listed (updated in real time) in an excel spreadsheet where the user can
click on one or more of them to open those files or at least retrieve
specific data from them?
I have a situation where files representing cost centres and each month of
the year need to present data into a worksheet used for reporting purposes.
So potentially 5 x 12 = 60 files. But these are only created as the months
pass. so at the end of month1 there would only be the 5 files, month 2 there
would be 10 etc. The files all have the same name excepting for the first 8
characters which identify the cost centre, year and month. e.g.
A2010JANSTANDARDFILENAME
Any suggestions appreciated.
PS Has anyone ever considered compiling an indexed resource with the
answaers to all these questions? Maybe this would be a marketable product.

You could have a list of the files and use a double_click event macro to
open and copy. Or, do all at once with one macro.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Wes_A" wrote in message
...
Good day all. Excel 2007. XP Pro.
Is there a way to have all available excel files in a particular folder
listed (updated in real time) in an excel spreadsheet where the user can
click on one or more of them to open those files or at least retrieve
specific data from them?
I have a situation where files representing cost centres and each month of
the year need to present data into a worksheet used for reporting
purposes.
So potentially 5 x 12 = 60 files. But these are only created as the months
pass. so at the end of month1 there would only be the 5 files, month 2
there
would be 10 etc. The files all have the same name excepting for the first
8
characters which identify the cost centre, year and month. e.g.
A2010JANSTANDARDFILENAME
Any suggestions appreciated.
PS Has anyone ever considered compiling an indexed resource with the
answaers to all these questions? Maybe this would be a marketable product.

This Excel add-in may do what you want. I wrote it...
http://tinyurl.com/ListFiles (download from MediaFire)
3 week trial, no advertising, no registration req'd.
--
Jim Cone
Portland, Oregon USA



"Wes_A"
wrote in message ...
Good day all. Excel 2007. XP Pro.
Is there a way to have all available excel files in a particular folder
listed (updated in real time) in an excel spreadsheet where the user can
click on one or more of them to open those files or at least retrieve
specific data from them?
I have a situation where files representing cost centres and each month of
the year need to present data into a worksheet used for reporting purposes.
So potentially 5 x 12 = 60 files. But these are only created as the months
pass. so at the end of month1 there would only be the 5 files, month 2 there
would be 10 etc. The files all have the same name excepting for the first 8
characters which identify the cost centre, year and month. e.g.
A2010JANSTANDARDFILENAME
Any suggestions appreciated.
PS Has anyone ever considered compiling an indexed resource with the
answaers to all these questions? Maybe this would be a marketable product.