VBA Code to Pull Data in from Folders & Sub Folders

  • Hello all,

    I was wondering if anybody could help. I have the following code which looks at a folder location (Directory = "C:\Users\John.wyldbore\Desktop\End of Year 2019\") and pulls in specific cell data from any spreadsheets within that location. How can I change this so it also includes any sub folders within that location as well please?

    C:\Users\John.wyldbore\Desktop\End of Year 2019\

    > Sub Folder A

    >1.xlsx

    >2.xlxs

    > Sub Folder B

    >3.xlsx

    and so on...

    Any ideas?

    Thank you in advance.

  • Try this:-