Progress Meter in Outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've written a VBA Macro that is pretty slow and the computer appears to have locked up. I know it running fine, it is just performing a lenghty process. Does anyone know how to display a Progress Meter in Outlook. I've tried the method described in MS Access but it is not recognized in Outlook.

Thanks,

Kenneth Romo
LT, USN
 
You would need to create and call a VBA UserForm that has a progress
bar control on it and init the progress bar control with a Min value
of 1, a Max value of the count of items you are working on and update
the control each pass through the loop.

You might not have a progress bar control available to you for use
though unless you had Visual Studio 6 or Office Developer installed on
your development machine and you would have to distribute and register
that ActiveX control (OCX) with your code.




BubbleHead said:
I've written a VBA Macro that is pretty slow and the computer
appears to have locked up. I know it running fine, it is just
performing a lenghty process. Does anyone know how to display a
Progress Meter in Outlook. I've tried the method described in MS
Access but it is not recognized in Outlook.
 
This is just something I'm doing in my spare time at work. We receive all of our message traffic via Outlook and usually get multiple copies from various sources. I created a VBA script that loops through and removes duplicates of the messages. I have VBA studio at home, I'll give your idea a try but I'm pretty sure our security settings here won't let me install ActiveX controls on these machines

Thank You

Ken Rom
LT, USN
 
Back
Top