Hi,
I Have a folder with +300 subfolders and within each one is a PDF and a xlsx file
I would like some code that opens each folder and copy's all the sheets in the xlsx files into one new workbook, the vast majority of workbooks have one worksheet but in a few cases there are more
Any help as always is greatly apricated
Kevin
Combine worksheets from multiple workbooks in one
You want the result workbook to have +300 worksheets?
Do you care what the result sheet names are or what file they came from?
There are lots of example code for something like this. Try searching for ...
excel vba merge workbooks in subfolders
Or this to be site specific...
excel vba merge workbooks in subfolders site:excelforum.com
Last edited by AlphaFrog; 10-30-2019 at 09:20 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Yes, 300 worksheets if possible
No, I don't mind
I will have a look at the links
Thank you for looking
Last edited by Excelski; 10-30-2019 at 09:39 AM. Reason: Cant find quotes!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks