Document Status Screen

Pestomania

Active Member
Joined
May 30, 2018
Messages
332
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have a VBA that runs through and creates pdf documents based on different criteria and it creates around 1500 documents total.

What is the easiest way to do the following things?

1. Create a "date, start_time, finish_finish, duration, average process time between managers and wifi name" excel sheet to track when the macros turn on and when they finally finish.
2. Have a screen or popup that provides a status complete. This would be based on the number of unique manager names in Column 9 and the number of completed manager names during the cycle (I have a for each macro that creates pdf files). I would hope to have this regularly update to see how far along it is.
3. Average time left to complete (this would be based on number of documents left to create multiplied by a standard X seconds).

Does this all make sense? I hope so.

Thank you
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,224,889
Messages
6,181,606
Members
453,055
Latest member
cope7895

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top