+ Reply to Thread
Results 1 to 2 of 2

List of Search file location path

  1. #1
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    List of Search file location path

    Hello Friends,

    i have some numbers of fileNames and want to search in my pc.
    i don't know where the file saved and also some of the files have saved in different location (Means drive C: or D.

    i just want to make a list of selected files path in Column A.

    Now i am doing
    Start
    Search
    putting file name with comma separated

    above search window show me the current path of the file.
    i want that path list(Filewise) in Column A.

    please suggest me.

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: List of Search file location path

    Here is a sample script for book1.xls and book2.xls for disk drives C: and F:

    Please Login or Register  to view this content.
    You would modify these lines to incorporate your filenames and your disk drives.

    Copy the lines (with your modifications) to a simple text file called mohan.bat

    Run the .bat file (with administrative privileges) and it will produce a .csv file on your desktop (it may take a while to run)


    The .csv will contain the full path
    Last edited by Jakobshavn; 03-29-2013 at 06:04 PM.
    Gary's Student

+ 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