Dialog changes

Removed "days pending check" as we seem to always want the days pending.
Removed "SNAP only" filter, and replaced "filters" with "progs to scan",
and added cash/HC/EA/GRH to this. In anticipation of the bigger overhaul
to-come with the PND2 script itself.
First major change to PDTE

The script now shows info for all programs, not just SNAP. The dialog
has been modified, and a new custom function included for
"convert_digit_to_excel_column", which converts a number to a letter for
Excel purposes. This will likely prove helpful enough to be included in
FUNCTIONS FILE.

Script now also allows multiple workers to be entered into the worker
editbox, separated by a comma (script splits them by comma).

Additional comments in code. More changes to come today. Stay tuned.
FUNCTIONS FILE update

I added a line in FUNCTIONS FILE to correct the
worker_county_code_determination function issues when I'm trying to look
at my own work. State folks are county 91, but we have "PW numbers" and
not "x191 numbers". Easy fix.
Second major change to PDTE

It now has buttons for lots more REPT screens, which will fit in nicely
for change #3: REPT generators all over REPT in MAXIS.

For now, I added the REPT/ACTV stats, as well as a piece to get COLA
income types from UNEA for these ACTV cases. COLA's coming, ya-know.

I also updated the PND2 dialog and created two new dialogs for "REPT
scanning". I might use them, I might not. Oh well, it's a branch, after
all. :)
Removed blip about old repo, added branches info
MSGbox at end

Supervisors are concerned that people aren't checking for changes to the
eligibility for medicare reimbursement for MA-EPD.
Better language for msgbox

Adding a message box to check for medicare reimbursement
MSGBox correctly

So much for this being a quick edit I gotta remember to slow down. .
Fixed the incorrect syntax.
Third major change to PDTE

Pull data into Excel now brings in EOMC info. It mainly just creates a
list, but does also contain data about autoclose percentages.
Fixed case number not autofilling

The dialog was after the "EMconnect". DO NOT ASK ME WHY, but when I
moved it to below the date calculations, it worked. Again, do not ask me
why. That was power slop.

Also, I tweaked the MsgBox at the end to say "Success!" in my usual
chipper way. This way, if I ever elect to run stats and include these
messages, I can get a better idea of our stats (by filtering "Success!"
messages from others.)
Added ERRR checking to script

It was getting caught up on the error-prone case warning. Added the
handy-dandy "ERRR_screen_check" function. Now it works. Woohoo!
FUNCTIONS FILE update

Added some error handling for Pine Tech on the
worker_county_code_determination function. It should now work for those
wonderful people.
Removed line of code

It was changing variables to 001 as it was reading the 01 variable as
one digit.
Updated CAF part 1 dialog

CAF part 1 dialog now includes info about HC document provided (if
applicable), as well as "faxed" as an option for how application was
received, and a new field for interview type (phone/office). All are
comboboxes.
Additional dialog changes

CAF 1 and CAF 3 were updated. Apparently the functionality to case note
the retro request was always in the script but no editbox was case
noting.

I removed the blip from CAF1, and updated CAF3's "HC begin date" to read
"retro request date". We'll pop it there.
Updated case note and dialog

Added previous dialogs to script, and updated the case note. As a recap:

Interview type (phone/in office/other)
HC document received (Req to apply/HC ER/other)
HC datestamp (date/text)
Retro request (date/text)
Fourth major change to PDTE

Split PDTE into subscripts ala DAIL scrubber? Why? Because it had become
so long it was challenging to dissect where I was going. This will be
easier to manage, plus it will allow for the insertion of more dialogs
if we need to.

Now, when I add LTC/GRH list gen to this script, it can be as a subset
as well. Saving button space, team!
Added a dropdown box

The dropdown box allows workers to select the type of approval they are
doing. So they can either select initial, renewal, recertification,
change, reinstate, or enter their own type if none of these fit. It will
then add it to the header of the case note making the case notes more
readable and obvious what kind of approval this was.
Moved convert_digit_to_Excel_col to FUNCTIONS FILE
Added case_number = "" for error handling

For some reason, every once and a while the script seems to get "caught"
on a case and derails. Apparently, it was navigating to REPTs under a
case number. I created a case_number = "" to avoid the issue.