I have a macro which opens six files into separate workbooks and then opens three different templates into separate workbooks and then opens three blank workbooks to paste data into for a grand total of twelve workbooks.
Obviously this taxes my memory so my question is: What would be the less memory hogging method of displaying all this data at once? With individual workbooks like I have it now or by having a single workbook with everything opening into worksheets? Or is it just a lot of data to display at one time either way I do it?
The six files are large: 32MB, 11MB, 90MB, 86MB, 85MB, and 7MB. I thought these large sizes might be too much for a single workbook to handle.
Obviously this taxes my memory so my question is: What would be the less memory hogging method of displaying all this data at once? With individual workbooks like I have it now or by having a single workbook with everything opening into worksheets? Or is it just a lot of data to display at one time either way I do it?
The six files are large: 32MB, 11MB, 90MB, 86MB, 85MB, and 7MB. I thought these large sizes might be too much for a single workbook to handle.