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.
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks