Progress bar

[TonyforVBA]

Im just asking this out of curiosity really but if I have a macro that generates 100 files and takes half an hour to run, is it possible to have a progress bar pop-up to show how much further is left to go in the query?

Cheers! Tony

[Domski]

You can write messages to the status bar such as: Processing x of y files

This is done using something like:

Please Login or Register  to view this content.

To return it to Excel's control you just use:

Please Login or Register  to view this content.

If you really want a progress bar though have a look here:

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

Dom