var fDesc=new Array(); fDesc[0] = "This time-saving macro will let you select a folder path and loop through each of the Excel files matching the file filter (default setting *.xl*) in that folder.

There are several ways to create a list of files in a folder and its sub-directories. The most commonly used object based model by Excel VBA developers to access the computer's file system is the FileSystemObject (FSO), which is available inside the Microsoft Scripting Runtime library."; function tShowHide(id, show) { var s = document.getElementById("desc"); if ((s.innerHTML.length<=212 || show==1) && show!=2) { s.innerHTML = fDesc[id]; if (document.getElementById('m1')) document.getElementById('m1').style.display='none'; if (document.getElementById('m2')) document.getElementById('m2').style.display='none'; if (document.getElementById('more_txt')) document.getElementById('more_txt').style.display='inline'; } else { s.innerHTML = ''; } }