Hai watersev. Please find the updated file.
1. Your original old scripts included in this file.
2. There is userform2 designed already for you to put your script.
Now every thing will remain the same as you have done before means Format, Output result, Everything. Rune the scripts to check the output result. The only one change in this file is it should generate reports with one button.
Note:
1. There is no CHIExpired/CCHIValid report because it will make complications when you write script because CCHI type is mandatory for other reports to generate.
2. Less then 02, 07 or 30 days reports is not required CCHI Valid or Expired validation. Means if i am running these reports then it should give me output. The script should not display a message saying that CCHI type is not selected.
If you ahve any doubt in this request please ask before you start. I don't want you to suffer and keep on doing rework.
Bookmarks