Open all files in folder

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?
Who is Participating?
in the visual basic editor... click tools/references and click microsoft scripting runtime
make sure you add a reference to ms scripting runtime under references
mak345Author Commented:
not sure i am following what you mean by that....
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.