Anders wrote ...

What I am doing:

1. A few thousand workbooks that have identical layout.
2. A macro xls with a range linked to one of the files in 1. above.
3. An Access mdb with a table linked to the range in 2. above.
4. A macro that loops through and links each file in 1. (such that the
Access linked range in 2. changes) and runs an append query using the linked
range as input and a second table as the append target.
ADO is used...
The problem:
After about 170 files the VBA macro crashes due to a "not enough memory"
error.

Could be:

BUG: Memory Leak Occurs When You Query an Open Excel Worksheet Using ADO
http://support.microsoft.com/default...;en-us;Q319998

Jamie.

--