I need a macro that opens all files in a folder into separate sheets of a single workbook

[HaakLord]

Hi all,
As the title says, I need a macro to open all .xlsx files in a folder on a shared Z: and compile them into a single workbook as separate sheets. The file names will change each time I use the macro as will the folder (Month to month, I can go into the macro and change the directory to the new folder I assume) that the files are contained in.

I searched and tried to use a few different ones that were written for similar situations but whenever I clicked 'Run' nothing would happen. The main difference I noted was that the people these macros were written for were opening files from their C:, although I don't see why this would make a difference.

Let me know if there is any more information I can provide! Thank you for any help!

[vpan]

Try this https://www.extendoffice.com/documen...workbooks.html
What you could do is have a prompt which ask you to choose the folder from the directory.

That path would stay variable based upon what you choose so you can choose a different folder/path each time.
instead of
Path = "C:\Users\dt\Desktop\dt kte\"
use as shown in code below
Path = .SelectedItems(1)

Please Login or Register  to view this content.