+ Reply to Thread
Results 1 to 1 of 1

File Path Formula for the sub Folder

  1. #1
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    File Path Formula for the sub Folder

    Hi just asking for help I just wanted to know what do I Need to do to get the file path with the Subfolder
    Here's the scenario:

    I have 4 Folders Under my main folder:
    Main_folder
    -----Folder_1
    -----Folder_2
    -----Folder_3
    -----Folder_4- 1 Excel files (Here's my Excel file to input the file path)

    And I want to get the file path of other folders 1 to 3 and put to my excel file under Folder_4

    Here's my formula But in that formula I only got the Folder_4 file path I wish anybody here can help me.
    =LEFT(CELL("filename"),SEARCH("\[",CELL("filename")))

    sample file i upload for the reference thank you so much in advance.
    Expected Result.PNG
    Attached Files Attached Files
    Last edited by jasond1992; 05-18-2021 at 01:41 AM.

+ 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. move files from Source Folder to Destination Folder, based on file name & Path
    By seenai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2020, 09:29 AM
  2. [Path location and Document macro]Require File , Folder and sub-folder path creator macro
    By Nitish Shrestha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2017, 02:23 AM
  3. Replies: 2
    Last Post: 12-29-2015, 04:19 AM
  4. Choosing folder path (instead of file path) in VBA
    By sminter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2014, 08:50 PM
  5. Code to list the folder path and sub folder path of a specific file
    By kalai1587 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 03:51 AM
  6. [SOLVED] Save As Dialog Box - Default Path and File Name, User Selects Sub Folder from Default Path
    By christenprochaska in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 05:17 PM
  7. Specified folder path to select file path
    By JayEmTee91 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2012, 10:38 AM

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