LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2003 macro generates compiler error on 2007 KenInPortland Excel Worksheet Functions 2 September 2nd 08 09:45 PM
application.filesearch error in excel 2007 Ramesh Excel Programming 3 February 11th 08 11:54 AM
Filesearch error in Excel 2007 Libby Excel Programming 4 February 8th 08 08:51 PM
How can I do the equivalent of "filesearch" in Office 2007? suzupis Excel Programming 2 August 6th 07 03:34 PM
Office 2007 Bizarre =@sum() formula BUG - generates mailto: hyperl funnybroad Excel Worksheet Functions 5 April 22nd 07 04:04 AM


All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"