Please supply a code snippet.

Bill Barclift

"chris" <yyyyy wrote in message
u...
I have a vba program which opens a new workbook, extracts data from an
access database into this workbook, performs some calculations, writed the
result to the workbook then saves it and closes it.

This works fine but I wanted to process several cases so I put in a for
loop
which goes thru the program several times. The first time thru the loop,
takes say 3 mins, then next time 6 mins and the next time about 15 mins
and
so on. If I run each cases singly, they take about 3 mins each.

Can anyone suggest what might be going on? Is there something that needs
to
be closed or shut down at the end of each pass thru the loop?

I am running windows xp and excel xp with 384meg ram

Thanks
Chris