N
Nuno Gomes
Hello,
I've a mdb that do the following process:
.. For each *.xls in a specific directory
.1 open xls
.2 made operation such as (copy, paste cells and create new sheets)
.3 insert the treated cells/sheets in a access table
.. End For
The problem is the point 2.
If the xls are small all works perfects but if the xls is big (for exemple
1000 lignes with 20 sheets) the process simple blocks with no error message.
I this is memory problems...
I try save the xls and close it after each sheet treatement; then reopen the
xls but have the same problem...
How i free the memory during this process?
Any ideias?...
Thanks, in advance
Nuno Gomes
I've a mdb that do the following process:
.. For each *.xls in a specific directory
.1 open xls
.2 made operation such as (copy, paste cells and create new sheets)
.3 insert the treated cells/sheets in a access table
.. End For
The problem is the point 2.
If the xls are small all works perfects but if the xls is big (for exemple
1000 lignes with 20 sheets) the process simple blocks with no error message.
I this is memory problems...
I try save the xls and close it after each sheet treatement; then reopen the
xls but have the same problem...
How i free the memory during this process?
Any ideias?...
Thanks, in advance
Nuno Gomes