VBA Text based Help (Pseudo Code Provided) - Hard/difficult/expert level?

Hi Everyone, So I need help with turning my pseudo code into VBA code. It's all text-based manipulation, and I've been struggling for 4 days with no success. --------------------------------------...