File folder info. in Excel workbook?

[Wes_A]

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.

 

[Don Guillett]

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.

 

[Jim Cone]

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" <[email protected]>
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.