	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

01/29/2009 at 08:48AM PST, ID: 24095260

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.6

VBscript or Macro that will combine multiple excel files into one file

Asked by benp986 in .NET Framework 1.x, Microsoft Dynamics, Microsoft Excel Spreadsheet Software

Tags: VBscript, Excel 2007, Macros

I am new to VBscript and have limited knowledge of Macros. I have searched around trying to find a macro or script to combine multiple excel files that are generated individually from Reporting Services in SQL into one excel file, and have each file as a worksheet in the file. There are several scripts that will do this, but only as the macro is run or by selecting the files. I need to have this run behind the scenes and pull the files automatically when the combined master file is opened. My thought was to have the reports that are being generated to go to specific folders with generic file names. For example Report1 folder will have files File1, File2, and File3. Then have the master file in a different location that when opened will pull these files to help refresh the data.

The problems that I am running into are that I can't find a macro or VBscript that will do this automatically.

I have users utilizing these reports that can't be asked to run several steps to combine the files, because it would be to confusing.

Finally, some of the reports are run every minute or 15 minutes to help keep the reports current and up to date, because these spreadsheets are used all day long for tracking and organizing. So, I need the master file to refresh when open or be able to refresh with a single click while the file is open.

Does anyone have any macros or scripts that I could use that would accomplish these tasks?
Thanks in advance for your help!

View the Solution FREE for 30 Days

20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625

1. TheLearn...20,200
2. abel16,985
3. Idle_Mind14,100
4. emoreau11,500
5. Dhaest11,052
6. CodeCruiser10,000
7. nmarun9,000
8. jpaulino8,900
9. ragi00178,000
10. cpkilekofp7,200
11. samtran0...5,500
12. mlmcc4,900
13. mwvisa14,875
14. aibusines...4,740
15. melmers4,400
16. jinal4,200
16. carl_tawn4,200
18. spprivate4,000
18. Chaosian4,000
18. RiteshShah4,000
21. tedbilly3,750
21. CraigWag...3,750
23. daveamour3,500
23. Senz793,500
25. cj_19693,375

1. TheLearn...27,700
2. emoreau20,000
3. abel16,985
4. Idle_Mind16,100
5. CodeCruiser12,000
6. Dhaest11,052
7. jpaulino10,400
8. ragi001710,150
9. mlmcc9,775
10. nmarun9,000
11. ChetOS827,500
12. cpkilekofp7,200
13. tedbilly6,250
14. samtran0...5,500
15. vavjeeva5,000
16. mwvisa14,875
17. elimesika4,850
18. aibusines...4,740
19. melmers4,400
20. jinal4,200
20. carl_tawn4,200
22. spprivate4,000
22. Chaosian4,000
22. RiteshShah4,000
25. TechTiger...3,890

VBscript or Macro that will combine multiple excel files into one file

Asked by benp986 in .NET Framework 1.x, Microsoft Dynamics, Microsoft Excel Spreadsheet Software

Tags: VBscript, Excel 2007, Macros

About this solution