I REALLY need a fix for the application.filesearch function that is currently in some old code which works in Excel 2003 and before but not in Excel 2007. I have heard suggestions on fixing this by using the Dir function but with my limited knowledge and no time I need expertise...PLEASE HELP!!!!
Call GetBrowse 'goes to a sub that allows you to pick a file with multiple excel files...after running through it jumps back to the Application.Filesearch below and gets stuck due to it being removed from 2007 With Application.FileSearch .NewSearch .LookIn = strPath .Filename = "*.xls" If .Execute() > 0 Then Workbooks.Add WrWrkBk = ActiveWorkbook.Name x = Workbooks(WrWrkBk).Worksheets.Count
sort = 8 For i = 1 To counter - 1 Application.ScreenUpdating = False strfile = .FoundFiles(i)