I guess you might need to show the code as you might be creating muliple
instances of each session etc...

also check that you are not creating multiple windows sessions - use windows
task manager.

Cheers
Nigel

"Anders" wrote in message
...
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.
I don't get it...
I'm running Win2000, Office 2000 on a 1GHz Dell with 500 meg of RAM...:(
Please help.

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.

--