Well, you won't evenhave to leave the ExcelForum for the code you need.
It's right here . . . . .
http://tinyurl.com/7djq3
If that link gives you any trouble, then...from any of the forum
pages:
Select the ExcelTips tab
Select "Files, Workbook, and Worksheets in VBA " from the list
Select "List files in a folder with Office 97 or later using VBA in
Microsoft Excel" from the next list.
Regards,
Ron
--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=379188