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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?)
 
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.
 
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
 
Back
Top