Code referencing the system clock?

[mcdowell]

I'm trying to create a progress indicator that is based strictly on the
system clock. The UserForm has two labels.... lblBottom and lblTop....
Processing time is 5 minutes using multiple macros which could include
an update macro. If anyone has a suggestion as to the code required?
I would really appreciate seeing it! Thanks in advance

 

[Tom Ogilvy]

Here is John Walkenbach's instructions on creating a progress indicator:
http://j-walk.com/ss/excel/tips/tip34.htm

Since you are opening files, you don't seem to want to admit that
a) the progress indicator must be updated by your code
b) while the files are being opened, your code is suspended.

If you wanted to progress the indicator every 30 seconds as an example
within your 5 minute span, then your code would need to be running at each
of the 30 second marks.

If this is possible, it would require use of the Windows api and some
separate process closer to the operating system.