View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default FileSearch in Office 2007 generates an error?

Using Office 2007 and Windows XP;

Since converting to Office 2007, the following generates an error on the
second line:

Dim ofsSearch As FileSearch
Set ofsSearch = Application.FileSearch

Error is "Object doesn't support this action"; has the FileSearch object
gone away? Or have I just been using it wrong in the past and Office 2003 let
you get away with it?

Could someone please offer an alternative to FileSearch? An example function
to pattern search for a file would be most appreciated. Thanks much in
advance.

Thanks!