[Solved] “Object doesn’t support this option” Error 445 in VB Code

Question

To get some help, you need to specify where you get the error. This time you’ve been lucky, I’ve recognized an error I went through some time ago.

Cause of the error

With Application.FileSearch

Error description

Run-time error 445: Object doesn’t support this option

Cause

The method has been removed since > Excel 2003. In later versions, in fact, the method has just been removed because of stability-security reasons.

Work-around

Someone (not me, I’ve just come through it for a replacement I quickly had to do) didn’t accept this change and has developed some alternative functions to embed in you VBA project and keep on using an “almost-the-same” approach. There are several through the web (by simply browsing alternative solutions to FileSearch after Excel 2003, here you find the solution I’ve implemented successfully; clearly you need to adapt it to your code but this is the way to go if you want to keep on using your current approach.

Accepted Answer

To get some help, you need to specify where you get the error. This time you’ve been lucky, I’ve recognized an error I went through some time ago.

Cause of the error

With Application.FileSearch

Error description

Run-time error 445: Object doesn’t support this option

Cause

The method has been removed since > Excel 2003. In later versions, in fact, the method has just been removed because of stability-security reasons.

Work-around

Someone (not me, I’ve just come through it for a replacement I quickly had to do) didn’t accept this change and has developed some alternative functions to embed in you VBA project and keep on using an “almost-the-same” approach. There are several through the web (by simply browsing alternative solutions to FileSearch after Excel 2003, here you find the solution I’ve implemented successfully; clearly you need to adapt it to your code but this is the way to go if you want to keep on using your current approach.