Hi Friends,
I am using macro in excel 2003. it work better, but when i use excel 2007 then some problem arisen in coding.
The code is:
This code run better in Excel 2003, But it can not run in excel 2007![]()
Set fs = Application.FileSearch With fs .LookIn = "D:\path" .Filename = "*txt*" If .Execute(SortBy:=msoSortByFileName, _ SortOrder:=msoSortOrderAscending) > 0 Then MsgBox "There were " & .FoundFiles.Count & _ " Text file(s) found.
will you help me to solve this problem
Bookmarks