Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding external Excel files and crating a dashboard.
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. -- trumb1mj ------------------------------------------------------------------------ trumb1mj's Profile: http://www.excelforum.com/member.php...o&userid=34847 View this thread: http://www.excelforum.com/showthread...hreadid=545924 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding external Excel files and crating a dashboard.
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. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=545924 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|