File folder info. in Excel workbook?
in [Programming]
|
Prev: Autofit row height in only some rows
Next: Track and write the number of times that sub is run into a cel
From: Wes_A on 19 May 2010 09:02 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.
From: Don Guillett on 19 May 2010 09:12
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 dguillett(a)gmail.com "Wes_A" <WesA(a)discussions.microsoft.com> wrote in message news:E6D12541-F0F0-4B08-BC99-F9024C3BE52F(a)microsoft.com... > 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. > |