| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
16.000 workbooks
hy, i have question regarding speed and memory allocation in VBA. As I mentioned in title I have 21 folder with few thousand subfolders and each containing 3, 4,5 or max 10 excel books. I'm writting procedures to copy some data from all these files into one file (I'm trying to create some database so I could use pivot or filter or sort...) My main issue is/was how to open one file and colect some data from 1000 different files into that one... But, even more, I'm wooried about memory limitations of my PC? because excel, after file is closed, still handles that memory space instead leaving it to Windows... so, after 1000 files everything is slow and after 5000 files... well i do not now yet... does anyone has any experience with some memory optimization technicues in VBA??? Thanks in advace, sasa |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel2007; workbooks.count is not counting all open workbooks | Excel Programming | |||
| Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
| suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) | |||
Threaded Mode
