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



    > Sub Folder B


    and so on...

    Any ideas?

    Thank you in advance.

  • Try this:-

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!