Finding external Excel files and crating a dashboard.

  • Thread starter Thread starter trumb1mj
  • Start date Start date
T

trumb1mj

Problem:

I have a folder where Excel files(.xls) are frequently being added and
updated. I need to build a "dashboard" type Excel file that can:

1) look in this folder
2) find any Excel files
3) take a totals row from these files
4) add the totals rows in a single row on the Excel file I am creating.
 
It would be worth recording this sequence to get m ost of the necessary
code. Then you can amend this with a section which uses the
DIR(Path*.xls) statement to get the list of files. Then just loop the
macro around.
 
Back
Top