Application.Filesearch : message 'Object does not support this act

[Howard Woods]

The macro failed on the statement

With Application.Filesearch

Presumably it requires a specific reference (Why does Help not tell you
which reference for peripheral facilities?)

 

[Howard Woods]

Thank you for the reponse.

Excel 2007 - 'Object does not support this action' - Windows XP

The code snippet was sufficient to throw the error.

I have since learned that for unexplained reasons Application.Filesearch has
been removed from the Excel 2007 implementation. I am doing a workaround
using the FileScriptingObject.

 

[Bill Manville]

You didn't say which version of Excel.
You didn't say what the full error message was
[the title of your message is truncated I think].
You didn't say which version of Windows.
You didn't give much context for your code snippet

- all of which could have helped us to help you.

In Excel 2002 no reference is needed to use Application.Filesearch.

Bill Manville
MVP - Microsoft Excel, Oxford, England