I have a workbook that contains a macro which, when
triggered, runs through a loop to open a number of other
workbooks. As each opens, a simple calculation is
performed on some data held in it and the result is added
to a new row in the original workbook. I guess I have two
questions really:
1. The process of opening and closing each workbook is
quite slow - is there a more efficient way of doing this?
2. If the answer to Q1 is no, then problem I have is that,
from a user persepctive, having all of these workbooks
flashing up on the screen will be irritating. Is there a
way of opening the workbooks but not displaying them (like
the personal.xls workbook) or of not refreshing the screen
while the macro runs (like the docmd.echo false command in
Access VBA)?

Thank you in advance for any help!!!