Application.filesearch help

[BigDelGooner]

Hi all

I have just been upgraded here at work from office 2003 to office 2010 and now the following code doesnt work...

With Application.FileSearch
        .NewSearch
        .LookIn = "[URL="file://\\LON0306.london.schroders.com\sim_spf$\Investment\Investment"]\\LON0306.london.schroders.com\sim_spf$\Investment\Investment[/URL] Selection\Fund Research & Documentation"
        '.LookIn = "O\Investment\Investment Selection\Fund Research & Documentation"
        .SearchSubFolders = True
        .Filename = "Fund Note"
        .MatchTextExactly = True
        '.FileType = msoFileTypeWordDocuments
    End With

It doesn't appear to like the application.filesearch command.

Any ideas?

 

[VoG]

It was removed in Excel 2007. If you search the board for filesearch you should find some alternatives.

 

[BigDelGooner]

Ahh..that would be it. Thanks Microsoft!

Thanks for your help VoG