Switching between open workbooks

Hi all - I hope you can help!

I am currently coding in Excel 2007 VBA. (Please forgive the likely very lax program coding you will come across in this post - I have had no formal VBA training!)

A brief description of the problem:

I recently created an intricate Excel 2007 based model for a large fuel cell company. The model outputs large output files which take time to analyze and open.

The client has asked that I create a concatenation program to take a number of output files (up to 8 - although if I can crack the problom for 2 files the extension to 8 should be trivial) and extract basic static graphs and tables for output to a small summary file which opens more quickly.

i.e. 8 large output files becomes one small summary file containing 8 sets of simple tables and graphs (without all the complex analysis that goes on in the output files).

I have enclosed a file named "summary file" which does the job that is required for 2 output files, but it requires me to continuously open and close files. Basically, I do not know a way of switching between open work books using a macro and my way of doing things will be painfully slow when I try to access the larger output files.

If any of you could offer a simple solution I would be extremely grateful!!!

Thanks,

Sam

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Please remove the word macro from the thread's title