References needed to run my code

[Doruli]

Hello I am trying to create a code that searches through the current directory and opens and reads every workbook in this directory
As a starting point I am using this code:
When I run the code I get the message "User-defined type not defined"

What references shall I ticked in order to make it work
I am using excel 2010

Many Thanks
Dora

Please Login or Register  to view this content.

[Leith Ross]

Hello Doruli,

You need to set a reference to the Microsoft Scripting Runtime library.