make numerous workbooks open in excel

**Tom123** · 11-09-2011, 07:51 PM

I'm working on a macro that copies certain data from the "full holdings" spreadsheet of about 10 different spreadsheets and puts it on the same number of worksheets within a single workbook called test-script. I need to then copy and paste additional data from the 10 workbooks and paste the additional data on to the 10 worksheets in the test-script workbook. I'm using a macro that goes through a list of names found in the test-script workbook. The first time I do the copy and past is pretty easy because my macro opens the 10 workbooks are active when they are open. The problem is making them active for the second time I need to copy data from the 10 open workbooks.

Here's the macro so far. All I need is code for making the 10 workbooks opens

Please Login or Register  to view this content.

Now i need to activate the source workbooks.

**Tom123** · 11-10-2011, 11:12 AM

Here's the workbook that has the macro. The list of source workbooks is only two to simplify development, but I'm going to include at least 10 source workbooks in the final macro

**jaslake** · 11-10-2011, 05:10 PM

Hi Tom
I'd assume you intended to attach a workbook

Here's the workbook that has the macro

I don't see it.

**Tom123** · 11-10-2011, 06:03 PM

here's the workbook

**Tom123** · 11-11-2011, 02:19 PM

Hello everyone. I have resolved my issues. It may not be an eloquent solution, but it works. Here's what I did. I realized that the first time my macro opened up the 10 worksheets that it made the sheets "active" so that I could highlight data and sort it, copy it and put it on my final workbook. I could figure out how to activate the 10 workbooks, however, which I needed to do to sort the data a second time in reverse order, highlight the results, copy and paste it into my final workbook. Then, I realized that I did know how to active the source works. That is, by opening the workbooks, I make them active, so I put in a command to close all of the open workbook (except for my main workbook) and then another command to open the 10 source workbooks, thereby making the workbooks active! I have completed my macro and am very excited about no long having to manual type in 800 points of data into the text documents that I write on a quarterly basis!