Hi,
I have a workbook which collects data from 80 other workbooks.
My macro is taking a painful 30 minutes to open, copy, paste and close all of those 80 workbooks.
I'm using workbooks.open(filename, True, True).
I've concluded that what takes time is opening the files, so I'm looking for a solution that could read data from another workbook without opening it.
Do you know any?
Thank you,
FC.
I have a workbook which collects data from 80 other workbooks.
My macro is taking a painful 30 minutes to open, copy, paste and close all of those 80 workbooks.
I'm using workbooks.open(filename, True, True).
I've concluded that what takes time is opening the files, so I'm looking for a solution that could read data from another workbook without opening it.
Do you know any?
Thank you,
FC.
