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

16.000 workbooks
 

To free up memory after code has been run set the variables to nothing,
set your strings to vbnullstring and clear your clipboard!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=39011