How do you envision this working?Say:You have folders: January 2016February 2016March 2016April 2016May 2016June 2016 in each folder you have 30 files (presumably Excel files)In your sample file, you said you "want to move all thirty sheets".Does that mean that there is only one sheet in each of the 30 workbooks,or that you only want to move one of the sheets in each workbook?Also: If you move the sheets, that means that the original workbook no longer has the sheetbut your new workbook now has 30 sheets.Is that what you want? or do you want to COPY the data from each of the 30 sheetsinto a single sheet of the new workbook? Do you want a macro to do all the folders in the "parent" folder or do you want to select which folder to process?
Attached are two files.Detach them and place them in the folder containing the
monthly sub-folders.
The "Template.xlsx" file is used as the basic template for the report for a
given month.The macro copies this file to a file called "PETTY CASH FOR " and
the name of the folder.
I created two buttons in the Composite_Macro.xlsb file.The first button creates
a list of the sub-folders "beneath" the folder where this file resides.
once you have the list of folders, put an "X" in column B for those you wish to
process.
then hit the "Gen Selected" button.
The report files will be in the same folder as the "Composite Macro" file.
To test, I created (6) folders, named "January 2016" through "June 2016".In
each folder, I copied your sample file 30 times (so I had 180 copies)
I then made reports for all 6 folders.
It took about 90 seconds.
hope this gives you enough to work with.
Paul-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
On Friday, January 6, 2017 11:45 AM, Izhar <[email protected]> wrote:
Hi everyone
I need help in the attach file, the question has defined in the attach workbook
and I hope there will be someone look into the matter.
Thanks in advance.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Template.xlsx
Description: MS-Excel 2007 spreadsheet
Composite_Macro.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
