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?
mak345Asked:
Who is Participating?
 
bobbit31Connect With a Mentor Commented:
in the visual basic editor... click tools/references and click microsoft scripting runtime
0
 
bobbit31Commented:
make sure you add a reference to ms scripting runtime under references
0
 
mak345Author Commented:
not sure i am following what you mean by that....
0
All Courses

From novice to tech pro — start learning today.