Copy data from a specific file from subfolders

  • I am trying to extract only few columns from 1 sheet from a specific file from all the sub folders. However, I am facing 2 problems:

    1. my code does not go into each sub folders to search for the files
    2. even if it searches for the file, it copies the data correctly, but I need to past the date which can be extracted from the sub folder name, or the file name. In the code I am trying to copy the date from the file name, but for some reason it is not pasting the date though it correctly identifies the part of the file name.

    The code is as below:

    Kindly help. Apologies if this has already been answered many times before


    Edited once, last by royUK: add code tags ().

  • samchannu

    18 posts and you are still not using code tags. Please read the forum rules and do as they ask.

    hi Roy, my apologies, I am not regular with my posts and had forgotten how tag the code. will take care henceforth.

  • c

    can someone kindly help me here. I am unable to resolve it here. Any help is appreciated.