+ Reply to Thread
Results 1 to 2 of 2

create a list of all results found within a ".search-ms" file

  1. #1
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    create a list of all results found within a ".search-ms" file

    Hi guys,

    Within windows you can use the "search" function to come up with a list of files (this is a ".search-ms" file)

    I am wondering if there is a way to save the results to an excel file?
    Column A = Name
    Column B = Date Modified
    Column C = Type
    Column D = Size
    Column E = Folder


    Getting Column E within an excel document, would allow me to filter through results and create some other macros that would be extremely useful for me.

    Thanks
    James

    I have attached a photo of what a ".search-ms" file search result is:
    Attached Images Attached Images
    Thanks,

    JimmyWilliams

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: create a list of all results found within a ".search-ms" file

    Not sure if this would help, but...

    On the Data menu tab, select Get Data > From File > From Folder... select a folder and load it into a worksheet.

+ 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] Search range for specific file and if found place "yes" next to it
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-28-2022, 10:48 AM
  2. Create a search box that marks "x" for multiple results found
    By sparerow in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2012, 12:31 PM
  3. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  4. Using "Find" to return results if a word is found within multiple words in a cell
    By pylauzier in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2011, 01:37 PM
  5. Replies: 2
    Last Post: 07-26-2010, 06:59 AM
  6. Replies: 2
    Last Post: 05-05-2008, 04:51 PM
  7. "IF" with "FIND" that results in #VALUE! (not found)
    By Ingeniero1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2007, 01:21 PM

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