Opening Multiple Workbooks from a macro with a twist
If you doing more than reading data from the files, you will need to open
them.
--
Regards,
Tom Ogilvy
"Doug" wrote in message
...
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
|