I need to create a macro that will allow me to summarize certain data from all .xls files located within the file location of the "summary" workbook. The names of the workbooks and the locations of the workbooks I need to summarize are all dynamic and change weekly.
I don't know if the files I need to summarize are going to be in the C: D: E: etc... This needs to be a portable tool. I want to be able to run this excel macro on anyone's machine in my office. Summarizing the data from physically identical workbooks. There can be anywhere from 1 to 30 workbooks in a given file location.
I cannot for the life of me figure out how to write a code that will look for all files within the "current" file's location. similar to active worksheets... I need it to look for .xls files where ever the currently open summary workbook is sitting.
Hope that makes sense. I feel dumb asking, but it is what it is.
Thanks, CB
I don't know if the files I need to summarize are going to be in the C: D: E: etc... This needs to be a portable tool. I want to be able to run this excel macro on anyone's machine in my office. Summarizing the data from physically identical workbooks. There can be anywhere from 1 to 30 workbooks in a given file location.
I cannot for the life of me figure out how to write a code that will look for all files within the "current" file's location. similar to active worksheets... I need it to look for .xls files where ever the currently open summary workbook is sitting.
Hope that makes sense. I feel dumb asking, but it is what it is.
Thanks, CB
