time till finished

[Guest]

Hello everyone,

I was wondering if anyone knows how to emulate the percent complete / time
till finished display that is used for software installations. I have a
fairly complicated set of macros that involves sequaentially opening
spreadsheets in thousands of subfolders and reading in and summarizing data
and this currenlty takes around three hours, but could potentially take much
longer as the number of files increases.

I was thinking of something along the lines of counting the total number of
subdirectories under the path, and then using a running average to calculate
average process time for the main do loop, and displaying this as a
calculated percent complete / time till finish status update.

Any thoughts or suggestions?

Thanks and as always greatly appreciated,

Jason

 

[Guest]

John Walkenbach has an example of a progress indicator:

http://www.j-walk.com/ss/excel/tips/tip34.htm

Regards
Rowan

 

[Bob Phillips]

Look at the Timer function in VBA help. Scatter Timer initialisations in
your code and then do some sort of output of the timings, a text file,
debug.print, or so on.

--

HTH

RP
(remove nothere from the email address if mailing direct)