fso - Microsoft Scripting Runtime Reference not working

[lydiapenrose]

Hello!
I have some code written that used to work fine in Excel 2007 once I added the Microsoft Scripting Runtime Reference. However, it is now giving me the same RunTime Error 5 with the debugger pointing me to this line of code:
Set FSfolder = FS.GetFolder(sFolderPath)

Is there another reference that contains the File Search capability?

 

[pgc01]

However, it is now ...

Hi

What is "now"? What is your excel version?

You don't give us information to understand what's happening.

About the variables FS, FSFolder, sFolderPath, post the

- declaration
- initialisation
- the value of sFolderPath when the statement you post is executed

 

[lydiapenrose]

Hi. So sorry to waste your time but I actually figured out what I was doing wrong. Thanks for replying though!

 

[pgc01]

No problem. I'm glad you figured it out.

The guidelines I posted are, however, valid for future posts. Always post your excel version, and declaration, initialisation and values of the variables in the code you post.