I have 5 large excel files approx 12Mb each in a folder and I am trying to
access them programmatically from another excel file in the same directory (a
report template). When I call code to open them like

Workbooks.Open Filename:=sName (thanks tom) it takes a very long time, like
the computer is running out of memory. Is there a way for excel to access the
Workbook-Worksheet programmatically without actually opening the excel file?

I need to process all of the excel files from a separate one rather than
sticking the same macro in each file.

this is doing my head in
Any help greatly appreciated
Cheers
Doug