Progress/Counting Meter Problem

Hi,

I have tweaked a Macro that extracts data from workbooks within a given folder.

I have tried using the progress meters from links in this forum, but i could not make them to work.

what i need is a wait massage to show how many files in a folder and how many workbooks are being copied.

Can anyone help me with this problem.

Here's my Macro

Please Login or Register  to view this content.

Thanks

Panic

Hi

Inside your loop add a line to update the status bar

Please Login or Register  to view this content.

Then as one of the last lines in your code add

Please Login or Register  to view this content.

to clearout the statusbar.

HTH

rylo

Originally Posted by rylo

Hi

Inside your loop add a line to update the status bar

Please Login or Register  to view this content.

Then as one of the last lines in your code add

Please Login or Register  to view this content.

to clearout the statusbar.

HTH

rylo

I tried as you suggested, but i do not see anything happening. I am I missing something?

Thanks

Panic

Hi

At the bottom of the excel window is a (normally) grey border that contains the word Ready. If you do a filter, it will give you the number of items that have been filtered, or if you highlight a column of numbers, and the default action is Sum, then it will show you the sum.

In that bar, where Ready normally goes, it should produce the message from the code.

Let me know if that doesn't allow you to find it.

rylo

Hi rylo,

Thanks this works now (i was looking at the wrong thing)

But is it possible to display the status bar information on a message or a userform?

Thanks

Panic

Hi

Can't use a messagebox as you have to keep acknowledging it, so it comes back to using the progress meter. I don't know what link you used, but there used to be instructions on the microsoft.com site on how to create a progress meter. I found those instuctions workable.

Try attaching a file with your progress meter code / userform etc and maybe we can find where it isn't working.

rylo