+ Reply to Thread
Results 1 to 3 of 3

VBA code "Application.FileSearch" not working in XL 2007 anymore

  1. #1
    Registered User
    Join Date
    12-15-2005
    MS-Off Ver
    2010
    Posts
    31

    VBA code "Application.FileSearch" not working in XL 2007 anymore

    Hi,
    Previous I wrote a VBA code using "Application.FileSearch" to loop through files in pre-selected folder + subfolder(s) for further processing & analysing.
    It work fine in XL 2003. But when recently my company start to use XL 2007. That code appear return an error.
    When I search through help file, i was told that that "Application.FileSearch" code been "hideen" (?) in XL2007 VBA.

    Please advice any method for me to loop through files in pre-selected folder (+subfolders if need) inside VBA code?
    Btw, I knew that is more code been hidden in XL2007. Just in case i need to find replacement for those code, any reference/site recommended?

    Thanks.
    Last edited by leecs; 06-09-2010 at 12:49 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: VBA code "Application.FileSearch" not working in XL 2007 anymore

    See this suggestion

    http://excel-it.com/Excel%202007/2007_filesearch.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: VBA code "Application.FileSearch" not working in XL 2007 anymore

    Most people find the use of DIr to be an adequate replacement for FileSearch but I have had major issues on computers running Office 2007 under Windows Vista. The end result was using the file system object method http://www.excelforum.com/excel-prog...not-found.html

    abousetta

+ Reply to Thread

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