Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 332
- Office Version
- 365
- Platform
- 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
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
