I want to loop through all files in a folder one by one....
I'm trying to use code in excel spreadsheets that includes
Dim TestFile As New FileSystemObject
and getting the error:
User-defined type not defined.....
I am using Excel 1997.....Is this not available in this version?
Is there any other way to go about this?