Web quieries and memory

[J.W. Aldridge]

I have a workbook that i recently updated. At first, it had about 20+
pages each with its own web query. I had one cover page that looked up
(several vlookup formulas) the values on each sheet according to the
date and compiled the information I needed.

On the updated version, I combined all the individual sheets (with
individual quiries) into one sheet. I spread the web quiries out (cell
a1, g1, j1, etc..). I still used the same cover sheet to retrieve the
data I need.

Now, the file has more than tripled in size (53Mb) and I am having
issues with even getting it open. When I run the macro to update the
quiries on the sheet, now it takes forever, locks up, or returns the
message that i dont have enough memory.

I thought reducing the number of sheets (20+) to 1, and combining the
quiries would help reduce the memory however the opposite has
happened.

Any suggestions? (store the quireies somewhere else? update on
open?.....)

thanx....j

 

[Don Guillett]

Without seeing the details maybe you could have ONE query >get the data>redo
the query with the new variable>get the data>etc. I did something similar
recently for a client to retrieve 4000 days of currency trading for about 40
sets of trades.