If you mean open the workbook, process it and close it, before opening
disable screenupdating and reenable after closing it (or after processing
all workbooks)

application.screenupdating = false / true

If you mean you don't want to open the workbook at all look into ADO,
http://www.rondebruin.nl/ado.htm

If you mean something else explain.

Regards,
Peter T


"Gustaf" wrote in message
...
How do you load a workbook from VBA, read data from selected sheets and
then close it, without it ever showing?

Also, is it necessary to check whether a workbook is already opened before
opening it, and closed before closing it?

Many thanks,

Gustaf