Looping problem, formula is summing all workbooks as it goes...

[curbster]

I have a bit of code that works well when I convert one file at a time. However, when I loop the macro to convert all folders in a file, it seems to tally up the sum from the previous file and add it to the current file as it converts. The more files it converts, the higher this particular number gets. It is still summing the correct # but it is adding previous workbook sums to it. Does this make sense?

Also, is there a better way to write this code instead of jumping to the very last possible row in excel before counting up? i.e. "C65536"

here is the code I am using:

Please Login or Register  to view this content.

thanks!

[Leith Ross]

Hello curbster,

It would be a big help if you post your workbook.

[davegugg]

I would say right after your begin loop code, put:

Please Login or Register  to view this content.

I was recently told the best way to do the last cell is:

Please Login or Register  to view this content.

Hope that helps!

[curbster]

Dave thanks for the code. I was able to get it to reset by placing the cellcount=0 in the line just below where I dimensioned "cellcount" and it worked! so thank you!

Also, the bit of code you gave to count to last cell worked in one area but not the others. Its probably how I've jimmy-rigged my code to work. I am really just a beginner. Anyone know how to shorten these lines to reflect the

Please Login or Register  to view this content.

that you gave me?

here is what I've come up with. it works but its sloppy and runs a bit slow throughout the loop.

Please Login or Register  to view this content.

Leith, I am working with a lot of sensitive information and since I'm starting with tab delimited text files I'm not sure how to post an example.

[ravishankar]

Hi
try these codes

Please Login or Register  to view this content.

Ravi

[curbster]

Hi Ravi,
Thank you for the code. I put it in and it sent me to someplace else in the code with a debug error so I think it is not looping properly. When I use the code I started with, it does work. I'm not sure whats causing it though.