How to show a Progress bar while macro is running in background?

[pradeepjassal]

Hi
I am working with a macro that opens 25 files to calculate an update the value in one standard sheet.
I have written code for steps I followed are as follow:
1)''' Select the Folder having required files.......
.....Application.DisplayAlerts = False
2)''' Creating List of All Files in Selected Folder.......
3)''' Renaming All Files in Selected Folder.......
4)''' Opening All Files in Selected Folder.......
5)''' Delete Previous Data in Standard Sheet.......
6)''' Update Data In the Standard Sheet Using the Open Excel Files.......
Now my requirement is to show a progress bar (Filling from 0% to 100%) on the main screen while all the steps runs in background.

Pradeep Jassal

[Sean Thomas]

Hi, this might help.

http://spreadsheetpage.com/index.php...ess_indicator/
regards
Sean

[pradeepjassal]

I have already tried this but was not able to implement the provided code. Pls suggest some alternate way.

[Sean Thomas]

Hi, i have attached a file with the progress indicator.
This eems to work ok.
What are you trying to do with it?

Sean

[Rajesh Balakrishnan]

I have several Sub modules in a Code which are called one by one.
Example
Call Initiate
Call Find_acc
Call Find_Acc_c
Call lookup_st
Call Failed
Call Cancel_AutoSettle

How can I show status on which sub procedure is running and the percentage completed

[protonLeah]

Rajesh Balakrishnan,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.