Opening Workbooks in a Folder
Dnia 29 Jun 2006 08:33:58 -0700, GregR napisał(a):
Piotr, how would I amend your Function to include subfolders and only
open the last modified file in each subfolder. TIA
Dealing with subfolders is not trivial when using Dir function (it cannot
be used recursively). You should probably read about FileScripting library
(or sth like that) - I've never used it, but recurring throught subfolders
is quite common task. Google should be helpful ;)
--
PL
|