Hi All,

I see that Application.FileSearch has been deprecated in Office 2007 and
that's
a bummer I really liked it's functionality. I had written a Visual Basic
macro to populate multiple worksheets in an Excel file from data I has
created from an SQR (Hyperion Software).

Can someone tell me the alternative for the following syntax?

If .Execute(SortBy:=msoSortByFileName, _
SortOrder:=msoSortOrderDescending) 0 Then"

Thanks for your help.