Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Application.FileSearch In Excel 2010

  1. #1
    criciuma Guest

    Application.FileSearch In Excel 2010

    Hi guys!
    I got this macro that opens all the files in the folder where the already opened file is located.It was functioning normally.
    However, now I am using the Excel 2010 and it is not working anymore.
    Which adjustment should I make it it still works in excel 2010?
    HELP!?
    thanks,



    PHP Code:
    Dim i As Integerwb As Workbook

    On Error Resume Next

    With Application
    .FileSearch
    .NewSearch
    .LookIn ActiveWorkbook.Path
    .SearchSubFolders False
    .Filename "*.xls"
    .Execute

    For 1 To .FoundFiles.Count



    Set wb 
    Workbooks.Open(Filename:=.FoundFiles(i))

    Next i

    End With 

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,628

    Re: Application.FileSearch In Excel 2010

    This is not your first post, and by now you would have been well aware of the forum rules. To reiterate, please take note of the following regarding thread titles:

    Thread titles are used in searching the forum, therefore, it is vital the be written to accurately describe your _thread content or overall objective_ using ONLY *search friendly key words*.

    * The title must not use non-essential words such as:"Help needed", "Formula problem", "Please help", "urgent", "Code issue", "Need Advice", etc. Such words dilute the title/search results.
    * The title should not contain VBA code or formula syntax or use abbreviations, jargon, delimiters
    * The title should not assume or anticipate a solution as in referencing Excel functions or VBA methods - the actual solution is often quite different


    Please note the change to your title, which is based on the objective stated in your thread.

    Application.FileSearch has been removed from Excel 2007 and 2010

    Try Substitute For Application.FileSearch

  3. #3
    criciuma Guest

    Re: Application.FileSearch In Excel 2010

    Thanks for changing. I hadn't noticed my title wasn't clear.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Application.filesearch
    By Scotchjim in forum EXCEL HELP
    Replies: 3
    Last Post: June 17th, 2011, 05:16
  2. Application.FileSearch Excel 2007 Help
    By Madalin in forum EXCEL HELP
    Replies: 1
    Last Post: April 21st, 2011, 22:02
  3. Application.FileSearch Fails in Excel 2007
    By Saurav in forum EXCEL HELP
    Replies: 2
    Last Post: July 13th, 2010, 22:15
  4. Application.filesearch
    By parrimin in forum EXCEL HELP
    Replies: 5
    Last Post: June 28th, 2007, 21:57

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
  •  
porno