+ Reply to Thread
Results 1 to 7 of 7

application.filesearch not working in excel 2007

  1. #1
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    application.filesearch not working in excel 2007

    I wrote a macro to list all the excel files from a directory and its sub-directories to an excel sheet. It is working in excel 2003 but shows error (object does not support this action) in 2007. Actually I have copied almost this entire macro from excel 2007 help only. Can somebody modify this to use in both the versions of excel?
    Please Login or Register  to view this content.
    Error occurs at the line
    Please Login or Register  to view this content.
    Last edited by johnjohns; 12-21-2009 at 05:24 AM.

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: application.filesearch not working in excel 2007

    johnjohns,

    Application.FileSearch is not available in Excel 2007

    See:
    http://www.mrexcel.com/forum/showthr...ht=fList%28%29

    http://www.ozgrid.com/forum/showpost...73&postcount=4

    http://www.thecodecage.com/forumz/ex...directory.html
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: application.filesearch not working in excel 2007

    Thank you Stanly

    But is this compensated in 2007 in any other way? Then perhaps I can use a version cheking and use the macro for 2003 and 2007. Any help is highly apreciated

    rgds

    johnjohns

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

    Re: application.filesearch not working in excel 2007

    Hope that helps.

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

    Free DataBaseForm example

  5. #5
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: application.filesearch not working in excel 2007

    Thank you Roy!

    A similar solution I got from Mr John Walkenbach's book also. But both these are not searching into sub directories. I think in 2007 macro side is not at all improved from 2003 and many features are missing also

    regards

    johnjohns

  6. #6
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: application.filesearch not working in excel 2007

    Here's a link to another tool from smurf, but it's not free

    http://www.codematic.net/excel-tools...filesearch.htm

  7. #7
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: application.filesearch not working in excel 2007

    Thanks a lot, all you wonderful people in this forum! Thanks for those immediate responses. Hope Microsoft may solve this issue in excel 2010 (I have not tried the beta version also yet). Or as Tylyn suggested I may go for a third party utility. Thank you all!

    Warm regards

    johnjohns

+ 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