Results 1 to 5 of 5

FileSearch Problem

Threaded View

mohan.r1980 FileSearch Problem 10-28-2010, 02:05 AM
royUK Re: FileSearch Problem 10-28-2010, 02:05 AM
ilyaskazi Re: FileSearch Problem 10-28-2010, 02:45 AM
JBeaucaire Re: FileSearch Problem 10-28-2010, 03:00 AM
mohan.r1980 Re: FileSearch Problem 10-28-2010, 06:18 AM
  1. #1
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    FileSearch Problem

    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:

    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.
    This code run better in Excel 2003, But it can not run in excel 2007
    will you help me to solve this problem
    Last edited by mohan.r1980; 10-28-2010 at 06:19 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1