error Progress bar

Hi,

Could you upload a workbook with the progress bar and at least one file that you would normally import? It doesn't have to contain any real data, but just any mocked up data to reflect the true workings of the process.

Also what error message are you getting and which line does it stop at?

abousetta

What sort of errors?

You really need to post example workbook so we can see how you have setup the progress userform. Also an example of the import file would help if that is related to the error.

First problem is you have set the max to 2000 but the i variable exceeds this.
I'm also getting lots of Out of Memory warnings but I'm not sure what is causing that.

I was thinking the same thing as Andy (I am honored to be on the same wavelength with such a well-know Guru). Your largest i is 5822. So you might want to make the maximum a bit a higher. For example:

Please Login or Register  to view this content.

abousetta

P.S. Not getting any Out of Memory Errors, so can't guess as to why this is happening also.

It is possible. The problem seems to be that the last part of the file is irrelevant to your import. For example the full length of the document is about 7500 lines but your "i" is only around 5900. What happens if I use the length of the file is that the progress bar progresses normally but then ends early because the last quarter is run extremely quickly. On the other hand, I tried to calculate the final number of "i" but now this is less than the length of the text file.

So I am out of ideas... sorry.

abousetta

This approach, using standard I/O, will allow you to determine size and position within the file being processed.

Please Login or Register  to view this content.

@copythat, if you are satisfied with the responses then please mark the thread as Solved.

Good luck.

abousetta