How to create a message box to keep track of progress
Hello,
I have a fairly sophisticated macro that opens some text files, imports some data, and then closes the text file. I have 112 of these files. Running the macro will run through all 112 files in chronological order. I have turned off the screen updating. The process takes about 5 - 10 minutes. Rather than look at what appears to be an inactive screen, I would like to display a message box that keeps track of the number of files processed during the run. How would I display a message box that would continually update as a new file gets opened and processed. I want the message box to always be present during the process with the only option to abort. Thanks, Jeff |
How to create a message box to keep track of progress
This gives the basic technique. If you don't want to show a progress bar,
put a message in the textbox. http://j-walk.com/ss/excel/tips/tip34.htm Displaying a Progress Indicator John Walkenbach's site -- Regards, Tom Ogilvy "Jeff Armstrong" wrote in message ... Hello, I have a fairly sophisticated macro that opens some text files, imports some data, and then closes the text file. I have 112 of these files. Running the macro will run through all 112 files in chronological order. I have turned off the screen updating. The process takes about 5 - 10 minutes. Rather than look at what appears to be an inactive screen, I would like to display a message box that keeps track of the number of files processed during the run. How would I display a message box that would continually update as a new file gets opened and processed. I want the message box to always be present during the process with the only option to abort. Thanks, Jeff |
All times are GMT +1. The time now is 10:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com