Re: Finding external Excel files and crating a dashboard.

Giganews Newsgroups
Subject: Re: Finding external Excel files and crating a dashboard.
Posted by:  mrice (mrice.28fgod_1148668503.6293@excelforum-nospam.com)
Date: Fri, 26 May 2006

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?action=getinfo&userid=10931
View this thread:http://www.excelforum.com/showthread.php?threadid=545924

Replies

None

In response to

Finding external Excel files and crating a dashboard. posted by trumb1mj on Fri, 26 May 2006