Multifile Excel import

[pjreynolds]

Hi folks,

This might be a long shot but, I'm trying to import a series of .xls files into one master worksheet automatically. The files all reside in a single directory, have unique (obvioulsy) but not sequential filenames and all have a single column of 100 rows (the cols/rows could be reversed)

How can I import all of the xls files in one hit, and compile the data into a single (or seperate) series of colunms (or rows)

I've had the FileSystem object suggested to me, but this seems to be a VBScipt/ASP function? (FileSystem in VBA seems to have nothing to do with importing data)

I know this VB not VBA forum, but any sugestions?

Thanks in Advance

Paul