+ Reply to Thread
Results 1 to 1 of 1

shell to search for a designated term in a designated folder

  1. #1
    Registered User
    Join Date
    06-27-2016
    Location
    NYC
    MS-Off Ver
    2007
    Posts
    1

    shell to search for a designated term in a designated folder

    Hi, at my job we have a big folder (CLIENTLIST) with subfolders for each of our clients. Within each client's folder there are subfolders for years, containing all the documents pertaining to that year for that client. Each year's subfolder has a file called "annual report." I'm trying to write a macro that opens up explorer, goes to the client's folder, searches through all the year subfolders for the annual reports, and shows the results. I've searched around quite a bit for help on how to do it, and this article was very useful:

    http://www.excelforum.com/excel-prog...op-search.html

    But when I copied the code from there (and adjusted it to my variables) I get a run error saying that " Windows cannot find ". " Any help would be appreciated. Here's my code:

    Please Login or Register  to view this content.
    **(obviously for the clientFolder variable uses the full path name, not "...")

    Thanks for helping!
    Last edited by drech; 06-27-2016 at 01:48 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Saving an Excel file in a designated folder
    By Buddy8 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-19-2016, 07:52 PM
  2. Creating a Designated Folder with Disabling cut Copy Paste and opening all files
    By Nimishk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2015, 09:58 AM
  3. Replies: 0
    Last Post: 04-21-2014, 04:03 PM
  4. [SOLVED] pop up message when user moves WB out of designated drive/Folder
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-23-2012, 05:09 PM
  5. Rename File Names & Repost to Designated Folder
    By Surfmaster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2012, 01:45 PM
  6. Search for old files by last accessed from a designated folder
    By bodiewil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-25-2010, 04:38 PM
  7. Auto-Populating from all files in a designated folder
    By taketwo in forum Excel General
    Replies: 3
    Last Post: 10-22-2009, 12:13 PM

Tags for this Thread

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