Hi,
I use a 3rd party add-in to download a bunch of data. If I try to download the entire data set my Excel gets frozen, so I use a loop statement to download one section at a time. With each step (500 rows), the Memory that Excel uses rises significantly reaching 1.4GB in no time, at which time I can't save the spreadsheet - the message pops up saying that I don't have enough resources to save the file. Even after I close the spreadsheet, the 1.4Mb of memory is still showing up in the Task Manager (with just Excel shell and no files). Can I do something with VBA to keep the Memory use low so that I could finish my data download and actually save the file? Any other ideas?
Thanks!
I use a 3rd party add-in to download a bunch of data. If I try to download the entire data set my Excel gets frozen, so I use a loop statement to download one section at a time. With each step (500 rows), the Memory that Excel uses rises significantly reaching 1.4GB in no time, at which time I can't save the spreadsheet - the message pops up saying that I don't have enough resources to save the file. Even after I close the spreadsheet, the 1.4Mb of memory is still showing up in the Task Manager (with just Excel shell and no files). Can I do something with VBA to keep the Memory use low so that I could finish my data download and actually save the file? Any other ideas?
Thanks!
