[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

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?
0
mak345
Asked:
mak345
  • 2
1 Solution
 
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
 
bobbit31Commented:
in the visual basic editor... click tools/references and click microsoft scripting runtime
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now